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

Highlighted
7 - Meteor
Spoiler
SPOILERChallenge_134_JR.PNG
Highlighted
Alteryx Certified Partner
Spoiler
screenshot134.png
Highlighted
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
Highlighted
13 - Pulsar

Here is my solution. 

 

Spoiler
Capture.PNG
Highlighted
8 - Asteroid
 
Highlighted
8 - Asteroid

Solution attached.

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

Fun!

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

My solution:

 

Spoiler
Capture.JPG
Highlighted
8 - Asteroid

My Solution:

Highlighted
8 - Asteroid