community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
SOLVED

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

Meteor
 
Alteryx Partner
Spoiler
Capture.PNG

My solution. Took me about 3 hours.

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!

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

 

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.

Alteryx Partner

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

Meteoroid

Attempt attached 

My First attempt in Weekly Challenge

Asteroid

Very fun. Took just over 5 minutes

 

Spoiler
challenge_125.jpg