Hello guys!
I was wondering if anyone could give a heads up or maybe show me a partial solution to this question.
Below you will find a task and an attachment of the dataset.
Task:
The provided dataset (in attachment) lists employee information including their employee ID as well as the ID of their manager. Every employee has a manager except the CEO whose manager ID value is null. HR wants to understand the reporting structure hierarchy within the company. How many employees have 3 reporting levels between themselves and the CEO not including their own level and that of the CEO?
Kind regards,
Alexander
Check this macro out https://community.alteryx.com/t5/Public-Community-Gallery/Hierarchy-Generation-Macro/ta-p/880709
Check this weekly challenge you might find workflow which might work for you https://community.alteryx.com/t5/Weekly-Challenge/Challenge-12-Creating-an-HR-Hierarchy/td-p/36740
Hope this helps : )
Hi @AlexanderHolzer , I was looking into this data set , though right now it is difficult for me to deal with it in Alteryx.
But here find my solution in Excel itself might it will help you.
Hint:-
feel free to connect anytime.
@atcodedog05 has provided the best links to look into it and learn from it. keep it handy for future reference.
111
Hi @AlexanderHolzer ,
Assuming that the reporting levels will not be a large number, I think you can achieve what you need by using JOIN, no need for macro.
Attached workflow for your reference.
Hope it helps.
Best Regards,
Lelia
@ncrlelia Could you explain step by step? I got lost in your reasoning.