In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
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

fmeo
8 - Asteroid
 
Koji_B
8 - Asteroid

Here is my solution

chetty
8 - Asteroid

My solution attached

JennyMartin
9 - Comet
Spoiler
AWC12.PNG

Definitely not the best way of doing this and wouldn't work if there was a level below analyst. Looking at other solutions it's clear I needed an iterative macro! Have gone back and built one now.

aazimh
8 - Asteroid

Definitely had to peek at pictures of other solutions for this one. Still find iterative macros hard to wrap my head around but great exercise! 

Assaf_m
11 - Bolide

learned a lot about iterative macros.

 

similar to the standard solution attached 🙂

jusdespommes
8 - Asteroid

Didn't use a macro, too lazy. 🙂

 

Spoiler
WeeklyChallenge12.PNG
BSilverblatt
8 - Asteroid

Thanks for the challenge! This is my solution.

Parul_Kapoor
8 - Asteroid

Solution attached.

Tomas_Kozlik
6 - Meteoroid

Not done by iterative macro but I have done this in like 10 minutes? I will deffinetelly look at it once I'm home from Prague Alteryx User Group.