Challenge #12: Creating an HR Hierarchy

[fluteman]

Here is my result.

I used a small reference table to create a rank based on position so i could complete the last bit!

Note: My Alteryx file for this one is like spaghetti. I did eventually get to an answer mirroring the goal.

[smoskowitz]

Hi there!

My solution seems to be in-line with others. Iterative macros are great! I just need to do them more.

[DN]

Spoiler

 

first time building a macro without filter tool. and it looks so... elegant

[NikitaParab]

Solved it again:

Spoiler

[Romy]

My current solution, a bit hard-coded, still trying to figure out the iterative version:

Spoiler

[michael_leoni]

Spoiler

Please see my solution below. 

[alexnajm]

Ooof, that was a rough one for me... definitely need to practice macros more!

[rayJ]

Nice challenge sharpening my macro skill. The macro option didn't come to mind at the first and only after checking the solution is the aha! moment.

Spoiler

without macro

[getintodata]

Great challenge for practicing iterative macros! Here is my solution, added a little part to dynamically sort the values

Spoiler

[BrandonB]

My non macro solution based on order

Spoiler