Hierarchy

[shivanand612]

Hello,

I need a help to solve the below problem

My input is

The output I need is 

If you share the workflow that will be helpful.

thanks in advance 

Shiva

[mot]

Hi @shivanand612,

Please check weekly challenge #12. It solves this case.

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-12-Creating-an-HR-Hierarchy/td-p/36740

I hope this helps. Best.