community
cancel
Showing results for 
Search instead for 
Did you mean: 
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.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #21: Date Reformatting

Meteor

attached

Nebula

My solution relies on the fact that the input data has to be in month order otherwise you wouldn't be able to disambiguate JJ, AA, etc.  I generate a month number based on row position and then extract a month name based on a intermediate date field

 

Dan

Asteroid

 

Hi, here is my solution

Asteroid
Spoiler
Challenge_21.PNG
Meteor

Easy Peasy 

 

 

Spoiler
Capture21.JPG
Pulsar
 

Sure wish everything was this easy.

Asteroid

Solution attached, mine is a little more long winded and assumes the dataset starts with Jan but it works in this scenario.

 

 

 

 

Asteroid

Here is my solution:

 

Spoiler
Alteryx Challenge 21 Solution.PNG
Highlighted
Meteor

Again, my method was much more intense than the solution file.