Weekly Challenge

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

Also available in | Français | Português | Español | 日本語
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

fluteman
7 - Meteor

 

Here is my result.

I used a small reference table to create a rank based on position so i could complete the last bit!

Note: My Alteryx file for this one is like spaghetti. I did eventually get to an answer mirroring the goal.

smoskowitz
11 - Bolide

Hi there!

 

My solution seems to be in-line with others. Iterative macros are great! I just need to do them more.

dssnek
8 - Asteroid
Spoiler
Capture.PNG

first time building a macro without filter tool. and it looks so... elegant

NikitaParab
8 - Asteroid

Solved it again:

Spoiler
NikitaParab_0-1605868297319.png

 

Romy
7 - Meteor

My current solution, a bit hard-coded, still trying to figure out the iterative version:

 

Spoiler
2020-11-23 16_13_41-Alteryx Designer x64 - challenge_12_start_file.yxmd.png

 

 

michael_leoni
8 - Asteroid
Spoiler
Please see my solution below. 
alexnajm
8 - Asteroid

Ooof, that was a rough one for me... definitely need to practice macros more!

rayJ
8 - Asteroid

Nice challenge sharpening my macro skill. The macro option didn't come to mind at the first and only after checking the solution is the aha! moment.

Spoiler
rayJ_0-1607702472231.png
without macro
rayJ_1-1607702489729.png

 

 

getintodata
8 - Asteroid

Great challenge for practicing iterative macros! Here is my solution, added a little part to dynamically sort the values

Spoiler
getintodata_0-1608042728384.pnggetintodata_1-1608042751338.png

 

 

BrandonB
Alteryx
Alteryx

My non macro solution based on order

 

Spoiler
Challenge 12.png