Parent child Hierarchy - Maximum levels

[TriptiAnand5]

I have a set of data having child and parent column and I want to build the hierarchy possible to one single top level without using multiple joins.

How can I do that using Alteryx?

My data looks like this 

[Gaurav_Dhama_]

Can you manually create an output and show what are you expecting.

[KGT · Accepted solution]

Have a search for Hierarchy macros on the community. There are a few around, but one main one that will get you the complete hierarchy for you to then parse. Without a macro, you will have issues with having to define how many rows to look at.

Also, I think it's challenge 12 in the Weekly Challenges, that deals with this. So that may be worth checking out as well.

[TriptiAnand5]

I want it to be like this , without having to define the number of parent, it should automatically search the number of parents possible up to the last level

[apathetichell · Accepted solution]

@KGT this one ---> https://community.alteryx.com/t5/Weekly-Challenges/Challenge-12-Creating-an-HR-Hierarchy/td-p/36740

 -- I think this was like the first iterative macro weekly challenge. Classic.I'd put this almost HOF level. HOF is like the Pokemon or Tire Size.