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.
Start Free Trial

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 #21: Date Reformatting

Karam
8 - Asteroid

Solution attached.

Inactive User
Not applicable

Very interesting challenge. Learnt a new tool!

adams_ca
8 - Asteroid
Spoiler
#21 Solution.JPG
cookl
8 - Asteroid

My solution

Inactive User
Not applicable

Here is my solution.

sann0638
8 - Asteroid

My non-ideal solution, which works given the format of the input.

Jasna_dm
7 - Meteor

Capture.PNG

Alekh
9 - Comet

Used regex to split to columns after the first character. I then used datetimeformat instead of manually giving a label for each month.

Spoiler
21..png 

 

KyleCollins
7 - Meteor

I thought this one was going to be cake. Could be much cleaner but I got there. 

MaddieJ
Alteryx Alumni (Retired)

My solution below! It was fun to look through the other responses as well :)

 

Spoiler
Mads_Challenge21.PNG