Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #12: Creating an HR Hierarchy

5 - Atom

Hi, I don't know if I can ask questions about the challenge in this forum or If I should be asking somewhere else but I was wondering how the system recognizes the Iterative output from the final one? Does it depend on order or on name? Are there certain rules? I got introduced to macros through this challenge and I'm trying t o understand how it works and how it applies to this challenge particularly. 

Thanks in advance! 

Laila

8 - Asteroid

The same solution as the one that was initially provided. 

8 - Asteroid

Solution attached.

 

Spoiler
Challenge 12 MP.png
7 - Meteor
Spoiler
Challenge12.PNG

 

8 - Asteroid

Definitely overthought on this one for way too long... Had to peek at solution for a Northern Light. Way simpler than my original attempts. 

Extra step to group by count of employee and sort count descending to get output nicely sorted by seniority (assumes role W/highest hierarchy count to CEO is most junior role) . 

 

Spoiler
RL_challenge12_Macro.pngRL_WK_12.png
8 - Asteroid
Spoiler
Challenge_12_solution.png

Here is the macro:

Challenge_12_macro.png
Alteryx
Alteryx

I ended up making 2 versions 1 hard coded and 1 using a macro.

Spoiler
Spoiler.PNG
8 - Asteroid

All,

 

This was a great challenge as I had never really used the Bridge Table.

Spoiler
Capture.PNG

-Cheers!

 

Matt

Alteryx
Alteryx
Spoiler
Screenshot.png
David Wilcox
Senior Software Engineer
Alteryx
Alteryx Certified Partner

I was waiting for a long time to finish this one as I didn't understand macro's at all before. But after doing more challenges I learnt how to tackle this as well 😄

Great stuff doing these challenges!

Spoiler
nothing more hierarchical in nature than mount everestnothing more hierarchical in nature than mount everest

Spoiler
fun use case for dynamic rename and dynamic select togetherfun use case for dynamic rename and dynamic select together