Challenge #12: Creating an HR Hierarchy

[patrick_digan]

Spoiler

I just did a simple iterative macro

[MaxGiegerich]

I'm aware we were supposed to use an iterative macro here (and I will do shortly for the practice!) but I feel the following solution works just as well and is simpler. I got used the Append Fields tool to get do a cross join then used some very basic logic to massage the data into the right format. One issue was the analyst's man_id is 2 but the manager's is 1. I'd assumed these have to be in order of seniority so this is a bug in the input data. Obviously this could be corrected manually but I haven't here (as surely that defeats the purpose).

*My mistake... man_id is clearly the ID of their manager, not the 'paygrade' or 'level' of seniority. There's probably a way of working this out using the cross join method but I'm going to go with the iterative method as it's more interesting and efficient (I'd imagine!) anyway. 

[siddhartha_s]

the suggested visuals can also be obtained in NodeXL an addin for network graph... Trying to get it all in Alteryx. Thanks for your response.

[JoshKushner]

What a great bridge table! Wrote an iterative macro to handle the hierarchy.

Spoiler

Bridge Macro:

 

[dsmdavid]

Quite some trial and error to get my mind around the iterative macro and only because @Phil_L57 was around...Not sure I still get it... but it works

[samN]

Well i feel whooped. Probably not the sanest way to introduce oneself to iterative macros...

[ggruccio]

Learned a lot about iterative macros in last year's Santalytics!  This one was fun!.

[LandonG]

It took a long time for this one to "click".

[PhilipMannering]

Solution attached.

Spoiler

[jasperlch]

Solution attached. A very good test on iterative macro.