Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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.