Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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 #122: Think Like a CSE...Ranking Data

kat
12 - Quasar
Spoiler
Seems to be the most common approach :)

Challenge #122.PNG
AGoyal
8 - Asteroid

This was quick and simple. 

 

PS: Can someone let me know where to find the macro for checking the output - I see some members have used it to validate output.

brgilbert
7 - Meteor

Similar solution as others have posted - two tools and expect equal to check.

patrick_digan
17 - Castor
17 - Castor

@AGoyal It's part of the CReW macros over here

jackie_liu
8 - Asteroid

Got to use a tool that I just learned over the weekend :)

 

Spoiler
challenge_122_jackie.JPG
mmongeon
8 - Asteroid

Here is my solution:

Spoiler
workflow 122.JPG

 EDIT : I see my solution is longer than most, at least it's different. ;)

KOBoyle
11 - Bolide

Solution attached. Similar to challenge #9, but with the more common ranking methodology.

Bahouth12
7 - Meteor

Here is my solution quick and easy.

StevenBetts
8 - Asteroid

Here's my solution

 

Spoiler
Always forget you can rename the Record ID field in the initial tool!

Challenge 122.jpg

 

 

 

mrichards
6 - Meteoroid

Looks like the standard solution

Spoiler
cse workflow.JPG