community
cancel
Showing results for 
Search instead for 
Did you mean: 

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #21: Date Reformatting

Alteryx Certified Partner

Solution attached.

Alteryx Partner

Very interesting challenge. Learnt a new tool!

Asteroid
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

Alteryx Partner

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. 

Alteryx
Alteryx

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

 

Spoiler
Mads_Challenge21.PNG