HR Hierachy

[numericalz]

Hi, 

I am trying to create a workflow that has an input of Employee and Manager Email (these are the unique IDs)

The output being 

Employee ID, Manager Level 1, Manager Level 2, Manager Level 3... 

With Manager level 1 being the highest person (i.e. CEO)

What do people think is the best way to complete this? 

[alexnajm]

Can you leverage something like this? Challenge #12: Creating an HR Hierarchy - Alteryx Community

[rzdodson]

@numericalz likely a nested iterative macro. At the first level, we would iterate all managers at that level, get the manager's direct reports, then return the list of directs. Then, once all managers are exhausted at that level, move to the next list.

Do you have sample data you're working from that you can share?

[numericalz]

Hi,

I don't have this data available to share, the current issue I have is that the data is not very clean but I am trying to make do with what I can.