Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
SOLVED

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

Highlighted
Alteryx Certified Partner

Solution to challenge 125.

Spoiler
Spoiler
Spoiler.png

 

Highlighted
12 - Quasar

This is one way, I guess.

Highlighted
Alteryx Partner

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

 

Highlighted
8 - Asteroid
 
Highlighted
Alteryx Certified Partner

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

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

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

 

Spoiler
Challenge 124 - Capture.PNG

 

 

Highlighted
12 - Quasar
12 - Quasar

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

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

 

Spoiler
Workflow 125.JPG
Highlighted
9 - Comet

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

7 - Meteor

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