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

acarter881
12 - Quasar

Here's my solution.

Spoiler
my_weekly_challenge_12_solution.png
Sebastian_Chaieb2
11 - Bolide
11 - Bolide

It was really challenging for me and really helped me to better understand how iterative macro works. 

That is why I am attaching two workflows (first standard workflow with the logic build using many joins, and the second as Iterative macro where multiple joins were replaced by iterations). SC

 

Spoiler
Sebastian_Chaieb2_1-1665392626872.png      Sebastian_Chaieb2_0-1665392544853.png

 

_Viktoria_
8 - Asteroid

solution without macro

martinding
13 - Pulsar

week12.png

Proud of myself! 

I also think this is a great use case for the Iteration Number variable.

Spoiler
Week12-2.png

  

Kinga
8 - Asteroid

Hi,

 

I prepared solution without macro. It was so obvious, that I wasn't able to understand why I should have macro...

 

Spoiler
Kinga_1-1666253406458.png

 

 

ahsanaali
11 - Bolide
Spoiler
ahsanaali_0-1666411586397.png

 

ivan_duniak30079
8 - Asteroid
Spoiler
Spoiler!ivan_duniak30079_0-1666444856313.png

 

OzlemSigbeku
8 - Asteroid

Needed a lot of work/support/help with this one - my brain was thoroughly teased.

OzlemSigbeku_0-1666624412509.png

Spoiler
OzlemSigbeku_1-1666624438047.png

 

TimN
13 - Pulsar

My solution.

NicolasSz
11 - Bolide

That one was a bit more complex !