Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
I really like seeing how others have solved this problem. My solution used a lookup table and managed months by identifying January with a mod function, then bringing month data in. I like how others have used the date parse tool.
After reviewing the solution, I realized that I took the long way around, but I did manage to get the correct answer. Here is my solution to the challenge.