Challenge #125: US Grand Prix Lap 1 - Data Prep

[PatForData]

Spoiler

[jjrbondoc]

Spoiler

[DelHansen]

Slow - didn't know the field summary join. 9 minutes.

Spoiler

[Watermark]

Spoiler

 

[Normster]

This one took me longer than 12 minutes because the end results didn't match.  Discovered that there were duplicate records for 1 employee, both with different termination dates and reasons.  That skewed my outcomes.  Since there isn't a record of the data/process that went into the solution data, I'm comfortable with my result.

Spoiler

Spoiler

[BSilverblatt]

Thanks for the challenge! Here is my solution:

[anabelvelazque]

Hi! Here is my take 😊

Spoiler

[Robinvm]

solved

[r_manju02]

Here is my solution

[davidhardister]

5-6 min or so (tip: don't rename the Date fields...)