Build Iterative Macro with 3 Columns for Hierarchy Chart

[BlueFalcon42]

Hi Community, 

I'm working on building a hierarchy chart similar to the ideal result shown in the image below. My dataset contains three columns: parent, child, and immediate parent. While I can manually join the data to achieve the desired result, my actual dataset is much larger, with up to 50 legs. 

I'm looking for assistance in creating an iterative macro in Alteryx to automate this process. Any guidance or examples would be greatly appreciated!

Thank you for your help!

 

[Qiu · Accepted solution]

@BlueFalcon42 
I always recommend this macro for this case.

https://community.alteryx.com/t5/Community-Gallery/Hierarchy-Generation-Macro/ta-p/880709

[BlueFalcon42]

Hi @Qiu, thank you for your recommendation! I came across this article as well as I was working to build an iterative macro, but I couldn't get it to work. In my Hierarchy Generation Macro, the results were returned in the 'O' output instead of 'R', which I am not sure why is that so.

I see that in both the macros, the input is using an arbitrary data source. Wanted to also ask for the macro inputs, it doesn't have to be from my database in order for it to generate the hierarchy chart based on my database. Do you know why is that so?