How to map out employee and their Direct/Indirect Manager

[icchung]

Hi All,

Much is appreciate for looking at this.

I'm trying to map out all the managers based on one employee. It's like a team of 5 employees will have 1 manager but I need to map out the manager's managers & upper managers.

Please see have a look at the Alteryx where it has the start data and the objective/result data. Thanks for looking at this.

Raw Data

Result

[Qiu]

@icchung 
This should help.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Crawling-Down-an-Org-Structure/td-p/44...

[Sebastiaandb · Accepted solution]

Hi @icchung ,

This might help, i based it on https://community.alteryx.com/t5/Weekly-Challenge/Challenge-12-Creating-an-HR-Hierarchy/td-p/36740 .

@Qiu 's reference might be a bit different so you have 2 ways to Rome now ;-).

Greetings,

Seb

[surajmthomas · Accepted solution]

My take on the requirement mentioned above. I have used levels of Find and Replace tool to get the result you have mentioned. @icchung 

[icchung]

Hi Seb,

Is it possible to save it in .yxmd, I am unable to open it in .yxzp thanks

[Sebastiaandb]

@icchung Here are both files individually. When you get that version error you can mostly still open the workflow by searching the folder that the package extracted. 🙂

Greetings,

Seb

[icchung]

Thanks for all your help much is appreciated!

[icchung]

Hi Sura,

This is a great. I have a question about using the unique node.

I have an employee who will have the same m1 but that m1 has TWO different managers in manager level 3. how to insure that is included? Is this not possible to cover?

e9 m8
e10 m8
m8 m11
m8 m12
m11 m15
m12 m15

Result for the manager8 with two managers. (is this possible to have?)

[surajmthomas · Accepted solution]

@icchung A bit of trickery involved. May not be the optimal way. But is this what you are looking for ?