Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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
Completed
Spoiler
Here is my approach
> Used formula tool to clean up and parse upstream
1. I removed " and ' using REPLACE () in the formula tool
2. I converted the date string from 16-JUN-01 to YYYY-MM-DD using replace and regexp_replace
I used Chat-GPT to help me with the syntax for both. I wouldn't know how to write this myself without looking at the documentation
> Then used the Text to Columns tool to split by delimiter,
> Used formula tool to clean up and parse upstream
1. I removed " and ' using REPLACE () in the formula tool
2. I converted the date string from 16-JUN-01 to YYYY-MM-DD using replace and regexp_replace
I used Chat-GPT to help me with the syntax for both. I wouldn't know how to write this myself without looking at the documentation
> Then used the Text to Columns tool to split by delimiter,
