Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

Tom_Luthi
8 - Asteroid

solution attached. It differs slightly from the standard solution since I assigned the Analyst Level 1 in the hierarchy, which makes more sense in my opinion.

wdavis
Alteryx
Alteryx

Completed without realising to do it as a macro. Following a longer process of joining at each stage!

AndrewS
11 - Bolide

#12 done.

Jonathan-Sherman
15 - Aurora
15 - Aurora

challenge 12 is done via a non macro solution!

 

Spoiler
challenge 12 JMS solution.PNG
Treyson
13 - Pulsar
13 - Pulsar

I have demo'd this workflow like 5 times, but I have never uploaded it! Here you go Iterative macro, may we never cross paths again!

Treyson Marks
Senior Analytics Engineer
JWS
Alteryx Alumni (Retired)
Spoiler

One of the harder once. Used a Batch Macro 
Capture.PNG
Etienne
8 - Asteroid

Solution below

Spoiler
clipboard_image_0.pngclipboard_image_2.png
ArnavS
Alteryx
Alteryx

Completed with first Iterative Macro

TonyA
Alteryx Alumni (Retired)

I struggled with this one as well. Never thought of using a second input for the macro so I went through a few gyrations. But at least it does work.

DanJ3
8 - Asteroid