community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #12: Creating an HR Hierarchy

Asteroid

I actually had the opportunity to use a spanning tree macro I had developed for another purposes to solve this one, which made me quite happy.

Alteryx Partner

I went for a nested iterative macro for this one.

 

Spoiler
12..png

 

 

 

This one tested me.  However, once I got it going I added two more employees to test the scalability of my solution.

When I started out I assumed I would need...

Spoiler
...a batch macro to contain an iterative macro.

012.png

Test with new employees:

output.png

Asteroid

I did it!!! My first iterative macro

Spoiler
Capture.PNG
Asteroid

I liked this challenge a lot! Great way to get used to iterative macros! Solution attached!

Asteroid

For more information see: https://www.imdb.com/title/tt0086827/

Alteryx Partner
 
Asteroid
Thank you for the exercise - Here is my proposed solution.
Highlighted
Asteroid

My Solution!!!

Meteor

Hi all,

 

I could not come up with a genius solution but a standard iterative macro:

 

Spoiler
Challenge_12_ownsolution.GIF

 

Take a look,

Regards,

Eren.