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

steven4320555
8 - Asteroid

took some time to figure out the cases, and punctuations. 

Spoiler
steven4320555_0-1586963754507.png


The data is not very clean, but it did not matter for the join. 

steven4320555_2-1586963929215.png

 

steven4320555_1-1586963894848.png

 

JeremyGonzva
8 - Asteroid

solution

AMansour
11 - Bolide

Hi, 

 

Here's my solution

 

Spoiler
Capture d’écran 2020-04-22 à 22.11.40.png

Cheers

Amr

iamme012397
8 - Asteroid

Here you go

terry10
11 - Bolide

 

Spoiler
ss 29.PNG


 

alexnajm
16 - Nebula
16 - Nebula

Done!

Sylvana
8 - Asteroid

My solution.

CKP
10 - Fireball

My solution

Spoiler
challenge_29_mysolution.jpg
Normster
8 - Asteroid

Took me a little bit to figure out why there were 253 records when we started with 252.  My Start file didn't contain the 2015 rankings either so I'm short 1 field.

 

Normster

cc000072
8 - Asteroid

Here is my solution, it was good for me to know how to use Dynamic Rename tool!

Spoiler
WeeklyChallenge_Ryohei_29.JPG