Weekly Challenges

Brente123 · ‎07-17-2018

Solution to challenge 125.

Spoiler

neilgallen · ‎07-18-2018

This is one way, I guess.

jvansistine · ‎07-18-2018

Took more than 5 minutes, but definitely less than 12. I confess that no one was watching or yelling at me. :-)

petgrap · ‎07-18-2018

Rachel_B · ‎07-18-2018

7 minutes. Will have to work on my speed if I want to win the Grand Prix :)

PhilipMannering · ‎07-19-2018

Took me half an hour... oh well, I won't be entering the Grand Prix anytime soon.

Spoiler

ggruccio · ‎07-19-2018

Was close to 12 minutes but....then I went over because...

Spoiler

I spent way too much time trying to clean up the duplicate employee number when there was nothing else to link to in either file....both employees started before the term dates so I could not say based on date logic this person termed then the other person hired on....

All of this was totally unnecessary! The output based on the field summary didn't care that the numbers were duplicated. Oh well live and learn!

I spent way too much time trying to clean up the duplicate employee number when there was nothing else to link to in either file....both employees started before the term dates so I could not say based on date logic this person termed then the other person hired on....All of this was totally unnecessary! The output based on the field summary didn't care that the numbers were duplicated. Oh well live and learn!

mmongeon · ‎07-19-2018

Fun! Here's my submission. I was able to do it in under 12 minutes.

Spoiler

TylerNa · ‎07-19-2018

The faster I try to go the more tools I end up using. Still managed to be under 12 minutes though.

javila · ‎07-19-2018

My solution attached! Took maybe 10min. That leading/trailing white space will getcha.

Weekly Challenges

IDEAS WANTED

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