Challenge #12: Creating an HR Hierarchy

[usmanghayoor]

Solved it without Iteratice Macro!

[FrederikE]

The solution is beautiful, mine not so much. 

Spoiler

[emartz]

This was interesting.  I am used to using a filter tool in an iterative macro and I could not get past generating rows.  I learned that you can have multiple inputs, and you can use the join tool to separate data to your iterative output and complete output.

[Jon-Knepper]

Spoiler

Here is my solution!

[James_Driver9]

Spoiler

[jbichachi003]

My solution!

Spoiler

I admit, this one had me stumped! Insead of having two Macro Inputs, I originally had one. Inside the macro, I had the Macro Input connect to both the Left and Right inputs of the next Join. It took me a long time, but I finally realized why this wasn't giving me the full output. I need one "whole" version of the dataset to be constantly fed into the macro. The iterative input is updated with each pass. Both are compared against each other.

Challenge 12 solutionChallenge 12 solution (macro)

[daniel_lcp]

done thx

[TonyAndriani]

Reposting to my new user ID.

[binuacs]

Spoiler

[RobbieA]

Tough one, good iterative practise

Workflow: 

Macro:

Slightly different macro than the solution, but same concept