Challenge #12: Creating an HR Hierarchy

[mgaronson]

Spoiler

 

 Macros tend to confound me. I found this tough to get through. Finally understood the 2 inputs were necessary.

[H_a_n_g_C_h_e_n__x3]

Practice

[MartinStraech]

Completed the challenge in two different ways. First, not using macro, but just adding an extra join for every hierarchy level. Wouldn't be tough to extend it if needed, but not really clean.

I hadn't done an iterative macro before, so learning how to get those set up properly was a good exercise. Also decided that the display order at the end should show the hierarchy at the same time too. ei Analyst -> Manager -> Director etc.

Spoiler

[jon_amanrich]

Not a simple one... First need to figure out about the iterative macro, then need to configure it accordingly!

Spoiler

[Chan_Baek]

It was my first challenge for iterative macro.

I didn't know it is available to make multiple inputs and outputs separately for iterating at the first.

[Krzysztof_Hyla_1986]

It took me a lot of trial and error but I think I finally figured it out :-)

[nikhilnijhar]

Spoiler

[Naomi_I]

Spoiler

Here's my solution!

[cjmayes]

done as team

[myastarling]

here's my solution. I had been putting this one off for *years* because I didn't know how to set up an iterative macro but after attending Inspire and getting a little more confidence, I did it! :-)