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
Highlighted
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
Asteroid

Hi. This is my solution. 

 

challenge_125_apabonok_spoiler.png

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

My Solution:

Highlighted
Asteroid
 
Highlighted
Asteroid

Challenge #125 solved!

 

Spoiler
nivi_s_0-1577420682735.png
Highlighted
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
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