Challenge #12: Creating an HR Hierarchy

[IssacTheBlue]

This one was tricky

[geop31794]

Please find my solution

[FlorianC]

I highly recommend the video training Build Your First Iterative Macro! available in the Academy to get a better understanding of the way iterative macro work.

Spoiler

WorkflowMacro

[GeraldJTessier]

Here my solution

[mattreynolds]

Wanted to make this accept varying input sizes, and scale beyond n=5 rows of input. We can view each employee-manager relationship as an edge in a directed acyclic graph. Using a V_WString as (approximately) a byte array to compactly represent those relationships, its easy to order the edges in the hierarchy. Ultimately, uses 2x joins to complete for any length of input up to ~30k rows.

[SilviaRox]

First I built a solution without using a macro. Then I managed to create one with a macro as well, but for this I had to have a peek at the solution.. well, it's my first macro ever  🙂

Good exercise.

[FredNajjar]

Spoiler

Workflow


Macro

[VizChic]

great to see you practicing the macros... up next is it the reporting tool? 😉

[szade1]

Challenging one!

[dmhatchell]

Spoiler