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
Alteryx
Spoiler
125_screenshot.png
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

MySolution.PNG
Highlighted
8 - Asteroid

Hi. This is my solution. 

 

challenge_125_apabonok_spoiler.png

Highlighted
8 - Asteroid
Spoiler
Challenge 125 2019-12-05.jpg
Highlighted
8 - Asteroid
Spoiler
sonyakasenkramer_0-1575643338102.png
Highlighted
8 - Asteroid

My Solution:

Highlighted
8 - Asteroid
 
Highlighted
8 - Asteroid

Challenge #125 solved!

 

Spoiler
nivi_s_0-1577420682735.png
Highlighted
8 - Asteroid
Spoiler
Hjardine_0-1577477789437.png

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
Annotation 2020-01-03 142351.png
Annotation 2020-01-03 142408.png