Flattening hierarchical records

Hi Everyone,

I am trying to understand how best to create a workflow to flatten a hierarchical data structure. I initially thought cross-tab and a join would work but I think it needs more, Any hints or suggestions would be much appreciated. I have attached a file with sample input and desire output.

Many thanks,

Arnab

Flatten_Input.xlsx

Workflow

Accepted answers

ardutta

Thank you. I will go through your solution and let you know if I have any questions.

All comments

ardutta

I solved this using a series of multi-row operations (see attached workflow) but it doesn't seem to be the most efficient approach.

Hierarchy_Flattening.yxmd

ImadZidan

Hello @ardutta ,

I looked at this and I thought it is a good scenario. When I looked at the data, there is one thing missing. The hierarchy link. There is nothing in there to identify what element belong to what level or item. That is the issue. If you just want the records to appear the way you in your output with no logic, that becomes easier.

The question here is this, How do you know the branches and which belong to which?

Please let us know.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703