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

SGriggs
7 - Meteor

attached

danilang
19 - Altair
19 - Altair

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

MattKing
8 - Asteroid

 

Hi, here is my solution

dillon_bok
8 - Asteroid
Spoiler
Challenge_21.PNG
aking
7 - Meteor

Easy Peasy 

 

 

Spoiler
Capture21.JPG
danrh
13 - Pulsar
 
OldDogNewTricks
10 - Fireball

Sure wish everything was this easy.

KMiller
8 - Asteroid

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

 

 

 

 

willstom1
8 - Asteroid

Here is my solution:

 

Spoiler
Alteryx Challenge 21 Solution.PNG
cmarchese
7 - Meteor

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