Build Iterative Macro with 3 Columns for Hierarchy Chart
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
Solved! Go to Solution.
- Labels:
- Designer Cloud
- Iterative Macro
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@BlueFalcon42
I always recommend this macro for this case.
https://community.alteryx.com/t5/Community-Gallery/Hierarchy-Generation-Macro/ta-p/880709
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
