Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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)

AYXAcademy
Alteryx
Alteryx

Inspire_Training_Banner_3337x600.png

 

Hi Maveryx,

 

A solution to last week’s challenge can be found here.

 

Are you already missing Inspire 2024? If you did not have the chance to attend the conference, the next three challenges will give you a taste of what our competitors faced during the incredible Grand Prix event, which celebrated its 15th anniversary this year. The year 2024 also marks 30 years since the tragic passing of Formula 1 driver Ayrton Senna.

 

Ayrton_Senna_-_Mclaren_MP4-8.jpgA huge congratulations to Molly Harras on winning the 2024 Alteryx Grand Prix! If you are not aware, Molly won the Grand Prix for two years in a row: 2023 and 2024. Her incredible skill and dedication have shone through!

 

The Grand Prix challenges are divided into three laps:

 

Lap 1: Data Blending and Preparation – June 10

Lap 2: Spatial Analysis – June 17

Lap 3: Predictive Analysis – June 24

 

 

Pit stops during a race can make or break a team. Using the provided datasets from three different races (Qatar, Silverstone, and Japan), identify the driver who executed the fastest individual pit stop, measured from entering to exiting the pit lane.

 

The solution should consist of a single row containing the following data points: [Driver], [DriverNumber], [Race Name], and [PitStopTime] (in seconds).

 

Note: Truncate times to the second before you determine the pit stop duration.

 

Feel free to use the hints provided in the workflow.

 

Need a refresher? Review these lessons in Academy to gear up:

 

Good luck!

 

AYX-Maveryx_Micro Identity-Maveryx Academy_wordmark.png

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

Spoiler
It took about 10 minutes for me. However, when I'm on stage, I don't feel like I can stay calm.

スクリーンショット 2024-06-10 234549.png
nSpire
9 - Comet
Spoiler
428.png

alacoume
9 - Comet

My (dirty) solution :  

Spoiler
Challenge_428.jpeg
Kenda
16 - Nebula
16 - Nebula
Spoiler
Forgot to put the workflow screenshot in a spoiler now it won't let me, so added as an attachment in the doc!
PhilipMannering
16 - Nebula
16 - Nebula

Solution Attached,

 

Spoiler
image.png
ahsanaali
11 - Bolide

 

Spoiler
428.png

 

 @PhilipMannering solution is a piece of art.

balajilolla2
9 - Comet
Spoiler
Solution Attached
Screenshot 2024-06-10 082219.jpg
lynnesonney
8 - Asteroid

Gotta love Data Prep!

 

Sure is easier without the lights and noise from the crowd

 

Spoiler
428.PNG

 

DataNath
17 - Castor
17 - Castor

My solution to #428.

 

Spoiler
428.png