Employee Manager org hierarchy

[abhishekyx]

Hi alteryx community, 

I need help solving one problem.

I want to do the mapping of Employee and Manager for org. hierarchy.

please see the sample data and output I am looking for (attached data file and output as well)

I would really appreciate your help here.

[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. 

[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/44...

Generate each tree branch for a hierarchy

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

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. 

[Sntrada]

Hi @abhishekyx, 

Sure, I attached a picture of the workflow. I'll attach screenshots of the configurations and results of the tools used in a separate reply. 

[ChrisTX]

See the attached file. to open newer workflow files with an older version of Alteryx.

[Sntrada · Accepted solution]

@abhishekyx 

Here at the other screenshots. 

Let me know if you have any questions. 

[Jonathan-Sherman · Accepted solution]

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.

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