Challenge #12: Creating an HR Hierarchy

[IJReed]

phew.... that was a tricky one! Great exercise!

[nini]

My Solution:

[joona_rauhamaki]

This was a lot of fun! 

My solution as attachment

[Sajeel_Kershi]

Got the macro to produce the same output as the required output. Enhanced the workflow to include CEO (No manager, hierarchy level 0) by union the macro output with the join (input file for left and right with join man_id = id)

[Mausam]

Not much different from the original solution as this was more of a learning for me. My first iterative macro in Alteryx.

[cplewis90]

Fun challenge!

Spoiler

[JonathanAllenby]

Here's my solution to challenge 12.
It should be able to handle any number of employee types and structures.

[HuwHallam]

Here's my solution. It took a bit of trial and error and I finally got the right result, but I've had to rely on the iteration limit to stop the process from just going round and round... Looking forward to looking through others' results to see how they get do it.

Thanks for the challenge!

[Ladarthure]

My solution