Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience
SOLVED

Challenge #125: US Grand Prix Lap 1 - Data Prep

Highlighted
Alteryx Partner
 
Highlighted
Alteryx Certified Partner
Spoiler
Capture.PNG

My solution. Took me about 3 hours.

Highlighted
Alteryx
Alteryx

Looking at most of these solutions that say they have slight discrepancies... Most of these match if you join on the 3 fields listed which would count as correct!

@JimmyG Glad I can chalk it up to overthinking it!

Highlighted

First attempt didn't quite work, and then I got distracted with something else and had to come back to this.  So I didn't time myself, but I got there.

 

 

Spoiler
WC125.PNG

 

Highlighted
Alteryx Partner

Here's my solution:

 

Spoiler
WC125workflow.PNG

Pretty simple workflow, although I did panic a bit near the end because I had never used the Field Summary tool and momentarily forgot that the instructions told us it would make the necessary output from the transformed data.

Really enjoyed the time limit for this one, it made it feel just that more competitive.

Highlighted
Alteryx Partner

I managed to do this challenge finally today (my first wokflow). Took me 40 minutes.

Highlighted
Meteor

Attempt attached 

Highlighted

My First attempt in Weekly Challenge

Highlighted
Alteryx Certified Partner

Very fun. Took just over 5 minutes

 

Spoiler
challenge_125.jpg