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
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
- 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
