Hi Alteryx Community,
I’m trying to build an iterative macro that expands a manager hierarchy from an employee file. My input file looks like this:
user id | staff number | name | manager name
I want the output to include multiple levels of managers, like this:
user id | staff number | name | manager | manager1 | manager2 | manager3 | manager4
Each manager column should represent the next level up in the hierarchy. For example, manager1 is the manager of manager, manager2 is the manager of manager1, and so on.
Could someone guide me on how to structure the iterative macro to achieve this? Any tips on handling potential loops or missing manager data , how to handle the dynamic renaming of column in the macro would be appreciated!
Thanks in advance!
