# Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience
SOLVED

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

Highlighted
Alteryx
Spoiler
Alteryx Partner

Not quite ready for the Grand Prix - just a matter of time.  I have now completed my 76th challenge.  Just 114 to go!

Spoiler
Process:
- Auto Field on both inputs
- Convert Date of Hire and Date of Termination to Alteryx format
- Convert Pay Rate to Double (tonumber(trim(Replace([Pay Rate], "\$ ", ""))))
- Join date on Employee Number
- Field Summary of all tools
- Changed order of data
- Joined with output data provided as check

Highlighted
8 - Asteroid

Hi. This is my solution.

Highlighted
8 - Asteroid
Spoiler
Highlighted
8 - Asteroid
Spoiler
Highlighted
8 - Asteroid

My Solution:

Highlighted
8 - Asteroid

Highlighted
8 - Asteroid

Challenge #125 solved!

Spoiler
Highlighted
8 - Asteroid
Spoiler

Cleanse personnel data to remove whitespaces and \$ signs. Join two data sets, use 2 datetime functions to make both dates date columns, select to rename columns and then field summary tool to join the answer with my workflow. All record joined.
Highlighted
8 - Asteroid

Not hard. But I have to say there's duplicate employee number. This is severe problem when we do actual work.

Spoiler