Share
Report
12Hello, I'm currently experiencing a problem with dataflows in power platform
I have an Excel file with a hierarchy in one line
eg:
ID lvl1 | Name lvl1 | ID lvl2 | Name lvl2 | ID lvl3 | Name lvl3
I'd like to transform this model into another structure using a dataflow.
The new structure is as follows:
ID | Name | ParentID
ParentID corresponds to the levels above that we saw in the first structure.
If you have any ideas, I'd love to hear from you. For the moment, the only solution I've found is this one:
- dupply each top level columns
- merge ID lvl | Name lvl | Parent lvl
- transpose columns
- split columns
But it's a lot of manual processing and the level structure can change over time (there may be new levels in the future) so my way of doing things requires modifications each time a new level is added.
Thank you
All responses (
Answers (
