How to map out employee and their Direct/Indirect Manager

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

ManagerLevel.yxmd

Custom Tools

Accepted answers

Sebastiaandb

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

ManagerLevel.yxzp

surajmthomas

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

ManagerLevel.yxmd

surajmthomas

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

Hierarchy_Community_suraj.yxmd

All comments

Qiu

@icchung
This should help.

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

Sebastiaandb

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

ManagerLevel.yxzp

surajmthomas

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

ManagerLevel.yxmd

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

ManagerLevel.yxmd

Macro.yxmc

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?)

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703