Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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 #428: Inspire 2024 – Grand Prix (Lap 1)

RashedDS
8 - Asteroid
Spoiler
428.JPG

CPAul
7 - Meteor
Spoiler
 
428.JPG

 

CSmith16
9 - Comet

Didn't Time myself because I am not interested in doing so really, more so the solution / end goal.

 

Here's what I got though:

 

Workflow:

Spoiler
Screenshot 2024-06-12 095602.png

Formulas:

Spoiler
Race Name: 
REGEX_Replace([FileName],"(\w*)(\-.*)","($1)")

PitTime:

"2024-06-12 " + REGEX_Replace([Value],"(\d\s.*\s)(.*)","($2)")

PitStopTime:

DateTimeDiff([PitTime],[Row-1:PitTime],"sec")

Screenshot 2024-06-12 095911.png
Screenshot 2024-06-12 095935.png

Solution Check:

Spoiler
Expected:
Screenshot 2024-06-12 095637.png

Actual:

Screenshot 2024-06-12 095625.png

 

Azzo89
6 - Meteoroid

My Solution

AGilbert
11 - Bolide

Pumped that F1 has an API!

 

Spoiler
Screenshot 2024-06-12 171407.png
JasperMB
8 - Asteroid
Spoiler
Challenge #428 JB.png

jdminton
13 - Pulsar
Spoiler
Snag_295bac65.png

binuacs
21 - Polaris
Spoiler
image.png
Dev73
8 - Asteroid

great show case of multi row formula tool 👨‍💻

Spoiler
challenge 428.jpg
Carolyn
12 - Quasar
12 - Quasar

@Qiu - I have nightmares about it 😂