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
Asteroide
Spoiler
428.JPG

CPAul
Meteoro
Spoiler
 
428.JPG

 

CSmith16
Cometa

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
Meteoroide

My Solution

AGilbert
Bólido

Pumped that F1 has an API!

 

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

jdminton
Púlsar
Spoiler
Snag_295bac65.png

binuacs
Polaris
Spoiler
image.png
Dev73
Asteroide

great show case of multi row formula tool 👨‍💻

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

@Qiu - I have nightmares about it 😂