community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.

Challenge #21: Date Reformatting

Alteryx Certified Partner

Solution attached.

Alteryx Partner

Very interesting challenge. Learnt a new tool!

Meteor
Spoiler
#21 Solution.JPG
Asteroid

My solution

Alteryx Certified Partner

Here is my solution.

Asteroid

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

Meteoroid

Capture.PNG

Asteroid

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 

 

Meteor

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

Moderator
Moderator

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

 

Spoiler
Mads_Challenge21.PNG