Challenge #12: Creating an HR Hierarchy

[Brian6]

that one made my head hurt

[yavdaanalytics]

Spoiler

[DavidP]

I had every intention of writing an iterative macro, I promise, but as I was messing around with the loop that I want to iterate through, I came up with this, which is annoying because I now have to start all over again to do it with a macro...

[DavidP]

Ok, here's my solution with iterative macro

[kelly_gilbert]

My solution is basically the same as the given solution. This took me way longer than it should have - I definitely need more macro-building practice!

Spoiler

Main workflow:


Macro:

[nnilz]

Learned a lot about iterative Macro's by replicating community solution

[JoBen]

That was a fun one! Cheers!

[S_Summers]

Done as a hard coded solution - need to now have a go at using iterative macros!! Not sure which bits would have to change if the hierarchy was deeper? Possible the append tool when it reaches a limit of 16...?

Spoiler

[pasccout]

Here is my solution... tried to get the Hierarchy set in the macro but could not do it... cannot pass an additional variable to the next loop (that I could find)... curious to see what your solution looks like...