Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
SOLVED

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

Highlighted
10 - Fireball

#125

Spoiler
125.PNG
Highlighted
6 - Meteoroid

Solution attached!

Highlighted
8 - Asteroid
Spoiler
JunePark_0-1588352348984.png

 

Highlighted
7 - Meteor

Attached is my completed solution.

Highlighted
Alteryx Partner

Solution:

Spoiler
TomProwse_0-1589895730309.png

 

Highlighted
11 - Bolide
Spoiler
 
Highlighted
8 - Asteroid

Piece of cake! Couldn't imagine doing this one on stage though! Gosh I'd be so nervous. I'd much rather uhm do a live stream on Twitch (!!!)

 

Also! If I solve one more then I'd have done 15 ... level up with a new badge!

 

Spoiler
izamryan_2-1590412592351.png

 

This is a 1-2 step, the combo of (1) Clean it! and (2) Solve it!

1. Clean

Needs two DateTime tools.
I like to use RegEx tool instead of the Formula tool, but my Regex for this was:
\W.(\d*.\d*)
which slices out the $ value in to a Double format column.

2. Solve

Then it's just a case of a Join
and a Field Summary
BTW if you use a Join Mutliple, I think it outputs a full outer join normally anyway.
For this one I'm using a regular Join - always (always!) check the results of the Left output tab and the Right output tab just to make sure you don't have any unmatched items.
Highlighted
8 - Asteroid
Spoiler
Solution Attached

balajilolla_0-1590935158337.png

 

Highlighted
8 - Asteroid

Highlighted
9 - Comet

My solution:

 

Spoiler
125 EW.PNG