Challenge #12: Creating an HR Hierarchy

[michael_apau]

my solution

[aaroncpotts]

This was really rough for me. I'll need to do this again to understand why it works the way it does better. I need more macro practice and will be doing that through my company soon.

Spoiler

  

[Johaon]

This is too tough for me now...... Can anyone explain to me how this loops? How are the conditions for loop termination reflected?

[Rhys_Cooper]

Excellent iterative macro question! solution attatched

Spoiler

[nayeli_jaime]

 Nice Challenge!

[snbandi]

My solution after peeking through others and understanding there is more to iterative macros than merely a Filter condition as loop iterator. Great tool.

[JWAJ]

My first solution was pretty dumb why I don't hide it with a spoiler. I hard coded the solution by taking advantage of the fact that the employees was ordered in management hierarchy in the input file. By adding a Record id it is possible to find the difference of the employee record ID with any potential manager record ID:

  

 I did not have experience with macros so i watched some youtube videos on how to use iterations in macros and came up with this:

Spoiler

 

[nli]

I found a solution without using a macro.

Spoiler

[Dev73]

got to learn the use of iterative macro

Spoiler

[asultanov]

Spoiler