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

[kiwiontree]

Thanks for the challenge. I am, however, missing the detailed approach in the solutions by milliseconds. Leclerc was a little bit "slower" than Tsunoda. 😄

[Tofel]

Spoiler

 

[ScottLewis]

Interesting example of how building for the case is different than trying to build a robust solution.

Spoiler

There are some bad pairs in the data that represent leaving or entering the pit at the beginning or end of a race. Ideally, you'd cull them before creating pit times. Here, I just let them be and threw out the resulting negative pit times at the end because that was faster. My solution processes the three races separately because I was concerned there would be differences in the requirements. Not going back and unioning earlier is another example of skipping a step for speed. 

[fmilliren]

Solved, and I also found a couple Pit-Out records without a corresponding Pit-In record.

Spoiler

Unmatched Pit-Out records.

Spoiler

[a640687]

Spoiler

[AnaKomissaroff]

My Solution

Spoiler

[nancychen]

Spoiler

[tammybrown_tds]

Spoiler

[Carolyn]

I got there eventually but, uhh, not in under 10 minutes. As soon as I'm timing myself, I forget how to use Alteryx 😁 But I didn't look at the Hint, so I'm calling that a win

Spoiler

 

[Qiu]

@Carolyn 
Felt the same.
Image how would we feel when stood on the stage. 😁