Employee Hierarchy: Senior to Subordinate

[abhishekyx]

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.

[atcodedog05]

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 : )

[abhishekyx]

@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]

Hi @abhishekyx 

Try this guide to downgrade the macro.

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

Hope this helps : )