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
