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!
