Challenge #12: Creating an HR Hierarchy

[lhalliwell]

Spoiler

 

[sunildeore]

This can also be solved using joins to same table (self join) if you know the depth of hierarchy & depth is smaller.

but using Iterative macro solves the problem of dynamic levels of hierarchy.

[gautiergodard]

Spoiler

Appreciated the community's help on this one!

[MajdiSalie]

Solution:

[danblythe]

Spoiler

Thought about doing a macro and decided it was overkill for how these challenges have been going.

[alacoume]

A macro was a bit too much for this one... So i do it easily even if i need to practise macros...

[kristiadiuisan]

Spoiler

Macro


Workflow

[KathrynMW]

Must read question fully before answering!  I didn't realise this needed a macro until after I'd solved it and looked at how everyone else had done it.  My bad!  Anyhoo, it does at least give the output required but I do understand why a macro might be better in real life.  And this is definitely one I should come back to and try again using a macro.  But for now, here's my more basic solution.

Spoiler

 

[keynguyen]

Spoiler

Macro: 

 

 

[almeera]