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

😵phew.... that was a tricky one! Great exercise!

Asteroid

My Solution:

This was a lot of fun! 

My solution as attachment

Asteroid

Got the macro to produce the same output as the required output. Enhanced the workflow to include CEO (No manager, hierarchy level 0) by union the macro output with the join (input file for left and right with join man_id = id)

Asteroid

Not much different from the original solution as this was more of a learning for me. My first iterative macro in Alteryx.

12.JPG

12_Interface_Designer_Settings.JPG

Bolide

Fun challenge!

Spoiler
Challenge 12 - w.PNGChallenge 12 - m.PNG
Alteryx Partner

Here's my solution to challenge 12.
It should be able to handle any number of employee types and structures.

Asteroid

Here's my solution. It took a bit of trial and error and I finally got the right result, but I've had to rely on the iteration limit to stop the process from just going round and round... Looking forward to looking through others' results to see how they get do it.

 

Thanks for the challenge!

Alteryx Partner
 
Quasar
Quasar

My solution