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 #29: Alteryx '16 Grand Prix (Race1, L1)

jamielaird
14 - Magnetar

Here's my solution.

 

Spoiler
challenge-29.PNG
patrick_digan
17 - Castor
17 - Castor
Spoiler
Capture.PNG
Natasha
9 - Comet

My solution is pretty standard to the above, it took me the most time to to figure out that I have 1 less column not because my join is wrong, but because there is no data for 2015 Ranks.

 

Spoiler
Screen Shot 2017-10-28 at 12.42.39.png
930realm
7 - Meteor

Took me reviewing the comments to realize the data was missing a field.

JoshKushner
12 - Quasar

This was fun :)

samN
10 - Fireball

Pretty much the same as the solution except used the data cleansing tool

Waynemk
8 - Asteroid

one more

ggruccio
ACE Emeritus
ACE Emeritus

Fun to try out a grand prix challenge!

PhilipMannering
16 - Nebula
16 - Nebula

Solution attached.

 

Spoiler
challenge_29 - Snip.PNG
LandonG
8 - Asteroid

Solution attached.