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

fluteman
8 - Asteroid

 

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
12 - Quasar

Hi there!

 

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

DN
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
16 - Nebula
16 - Nebula

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