Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Weekly Challenges

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #12: Creating an HR Hierarchy

AnnaLawrence
Alteryx
Alteryx

Got it

alisonpitt
11 - Bolide

I feel certain this could have used fewer tools in the macro, but considering this is the first time I've gotten an iterative macro to work on my own, I'm leaving it!

Spoiler
challenge-12-macro-AP.pngchallenge-12-workflow-AP.png
Amol_Telore
11 - Bolide

Attaching my solution here.. This solution will work even if hierarchy is not in sequence.. 

Spoiler
Amol_Telore_0-1657040340676.png

 

peter_gb
10 - Fireball

Nice little iterative macro was the way I figured this one out

Spoiler
challenge_12_pgb.png

Albert_Vega
8 - Asteroid

Complete! This one was fun!

sgreenough
8 - Asteroid

Solved!

Brian32
8 - Asteroid

Challenge Solution

Spoiler
Brian32_0-1658172582703.png
Marko_Bondaruk
6 - Meteoroid

I count myself to the very beginners with alteryx, this was challenging, and probably my solution is not very efficient, but still I got needed result. 

The very con of my approach it that it is not dynamic, but please don't judge me :)

 

Spoiler
Marko_Bondaruk_0-1658604416722.png

 

 

jwilson1
7 - Meteor

Challenge 12 solution

LukasJennings
8 - Asteroid
Spoiler
LukasJennings_0-1659360071264.pngLukasJennings_1-1659360081470.png