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
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.
@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.
Can you manually create an output and show what are you expecting.
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
