Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

Challenge #134: US Grand Prix Prelims - Email Dates

jridleh
7 - Meteor
Spoiler
SPOILERChallenge_134_JR.PNG
kmcdaniel
8 - Asteroid
Spoiler
screenshot134.png
SueDonim
8 - Asteroid

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
ponraj
13 - Pulsar

Here is my solution. 

 

Spoiler
Capture.PNG
Carlo_SKay
8 - Asteroid
 
KMiller
8 - Asteroid

Solution attached.

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

Fun!

Spoiler
Annotation 2020-01-02 231246.png
ddiesel
13 - Pulsar
13 - Pulsar

My solution:

 

Spoiler
Capture.JPG
sachinw
8 - Asteroid

My Solution:

rmassambane
10 - Fireball