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.

Challenge #134: US Grand Prix Prelims - Email Dates

7 - Meteor
Spoiler
SPOILERChallenge_134_JR.PNG
Alteryx Certified Partner
Spoiler
screenshot134.png
Alteryx Partner

Interesting target.  I never heard Ken Lay, but I did hear Jeffrey Skilling speak at a risk conference about a year before all this blew up.  He was a fascinating speaker, and was really onto it - or so it seemed.

 

Spoiler
Process:
- Filtered out all records not beginning with "Date:"
- RegEx to extract the date
- PadLeft to add a "0" where needed
- Convert to Alteryx date
- Sort by date
- DateTimeDiff to calculate days between emails
- Clean-up

MySolution.PNG
13 - Pulsar

Here is my solution. 

 

Spoiler
Capture.PNG
8 - Asteroid
 
8 - Asteroid

Solution attached.

Spoiler
19-12-2019 08-42-19.png
8 - Asteroid

Fun!

Spoiler
Annotation 2020-01-02 231246.png
12 - Quasar

My solution:

 

Spoiler
Capture.JPG
8 - Asteroid

My Solution:

8 - Asteroid