Employee Hierarchy: Senior to Subordinate

Question

Dear Alteryx Community,

I am looking for solution for employee hierarchy where I should be able to get the direct AND indirect reportee of senior manager.

I am able to get the output till direct reportee of senior manager but not able to do so for indirect reportee of senior manager.

I would really appreciate your help here.

attached excel and image file for reference

Thank you.

Example Emp Hierarchy.xlsx

Example_Emp Hierarchy.PNG

Example_Emp Hierarchy1.PNG

atcodedog05 · Answer

Hi @abhishekyx

Try this guide to downgrade the macro.

https://community.alteryx.com/t5/Engine-Works/Making-Workflows-Apps-amp-Macros-Backwards-Compatible/ba-p/779546

Hope this helps : )

abhishekyx · Answer

@atcodedog05 thank you for the prompt response. I am using tad old version of alteryx and the macro from the link you shared is not supportive.

atcodedog05 · Answer

Hi @abhishekyx

Check whether this works for you https://community.alteryx.com/t5/Public-Community-Gallery/Hierarchy-Generation-Macro/ta-p/880709

Hope this helps : )