Weekly Challenges
Solve the challenge, share your solution and summit the ranks of our Community!Also available in | Français | Português | Español | 日本語
IDEAS WANTED
Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEA
SOLVED
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
- 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
Hi. This is my solution.
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.
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.
Not hard. But I have to say there's duplicate employee number. This is severe problem when we do actual work.
