alteryx Community

# 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.

## Challenge #428: Inspire 2024 – Grand Prix (Lap 1)

Alteryx

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.

A 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!

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.

9 - Comet
Spoiler

8 - Asteroid

My (dirty) solution :

Spoiler
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!
16 - Nebula

Solution Attached,

Spoiler
11 - Bolide

Spoiler

@PhilipMannering solution is a piece of art.

9 - Comet
Spoiler
Solution Attached
8 - Asteroid

Gotta love Data Prep!

Sure is easier without the lights and noise from the crowd

Spoiler

17 - Castor

My solution to #428.

Spoiler