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 #31: Alteryx '16 Grand Prix (Race 2, L1)

Verakso
11 - Bolide

I am getting better of this but still not near the finish line and the 🏁

 

My official time for this challenge was 10:28:78 

 

And it looked like this

Spoiler
Pretty straight forward simple

I still seem to struggle with the Text To Columns tool, when you would like to split on more than one character at the time,
So here I did a replace of " - " to "|" first, so I easy could split on the pipe-sign and then avoid any white space afterwards
My WorkflowMy Workflow

Still on my way to Lhotse Face
/Verakso

RobertoEstrada
8 - Asteroid

It took me about 5 minutes to solve it. I love it, I recommend to read instructions often so you make sure you are working on the right direction.

wdavis
Alteryx
Alteryx

Slightly different solution using Select Records and then joining on Surf Site after parsing out the data from Surf Site locations files 

PhilBalderson
8 - Asteroid

Nice! 

RWvanLeeuwen
11 - Bolide

Done within 10 minutes - forgot about the time though as I was too caught up in the moment

 

Spoiler
31.png
ChrisMelck
8 - Asteroid

Can we include recommended times on all weekly challenges? Very useful. 6 mins for me on this one.

joemkcarr
8 - Asteroid
 
Hannah_Lissaman
11 - Bolide

My solution :)

papalow
8 - Asteroid

Finished but a little over the 10 minute mark.  I need more training before I will be a grand prix racer.  

Lily_Unsworth
8 - Asteroid