Challenge #12: Creating an HR Hierarchy

[justynam]

ufff, finally I got it!
It was great way to force me to understand iterative macros :-)

thank you

[Jim7]

This was a nice exercise for getting familiar with iterative macros. Thanks!

[justin_winter]

Yuck, just not good at iterative macros! Need to work on these a lot more!

[aking]

First time making a Macro so it was a but tricky but a good learning experience. 

[Mikkel_D_Karlsen]

My Solution

[ydmuley]

Very different from the actual solution and even solution by others.

Took a little time considering it was a Macro!

The solving thrill continues!!!!!!!!!!!!!!!!

This is how my macro looks like and the solution is attached.

Spoiler

[Kenda]

Spoiler

Once I added the RecordID, this made my solution much easier. This assumes the input is in order with each employee's manager appearing one row below them in the list.

[OldDogNewTricks]

This one was fun.  I did it pretty much the same as the solution provided.  I think that it may have been easier with a recursive query in SQL though.  ;) 

The one major difference was that I created a record for the CEO (he manages himself).  I don't think the CEO would be too happy to be left out!

Spoiler

[jevon]

Eventually had to look at the solution, but for a first iterative macro Alteryx challenge I'm glad I got somewhere along the right lines!

Spoiler