Employee Manager org hierarchy
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Here are some related posts:
Crawling Down an Org Structure
Generate each tree branch for a hierarchy
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks @ChrisTX for the response. I did check the 3rd link but I am looking for something more specific.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
See the attached file. to open newer workflow files with an older version of Alteryx.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
