Employee Manager org hierarchy

In order to ensure the workflow is fully dynamic and ensure you are also including "managers" with no "employees" i would take a similar but slightly different approach to @Sntrada.

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow (in version 2018.1) for you to download if needed. Simply configure the input tool to connect up your input file and run!

Regards,

Jonathan

20200707 - CreateHeirachy.yxmd

All comments

Sntrada

@abhishekyx

The attached workflow does this. You might need to split to more columns, depending on what your actual data looks like.

Let me know if you have questions.

Solution.yxzp

ChrisTX

Here are some related posts:

Crawling Down an Org Structure

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

Generate each tree branch for a hierarchy

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Multilevel-Product-Hierarchy/m-p/422343#M78326

Alteryx Weekly Challenges #12: https://community.alteryx.com/t5/Weekly-Challenge/Challenge-12-Creating-an-HR-Hierarchy/td-p/36740

In this example, we have a series of records where you have an employee title, an ID to the title, and the number of the managers’ title ID.

Chris

abhishekyx

@Sntrada Thanks for the response. Could you please share the screen shot of the workflow. I am on the old version of alteryx or could you just share the workflow.

abhishekyx

Thanks @ChrisTX for the response. I did check the 3rd link but I am looking for something more specific.

Jonathan-Sherman

Hi @abhishekyx,

In order to ensure the workflow is fully dynamic and ensure you are also including "managers" with no "employees" i would take a similar but slightly different approach to @Sntrada.

Regards,

Jonathan

20200707 - CreateHeirachy.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703