Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
Start Free Trial

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

Inactive User
Not applicable
 
apabonok
8 - Asteroid

Hi. This is my solution.

 

Illya
8 - Asteroid

My solution. Interesting, not sure how this would hold up with real world data, looking forward to going though other solutions.

aihnen
8 - Asteroid

Solution attached. 

 

Spoiler
Joined with a table with corresponding month values as well. Then year using Regex and replaced Null values in corresponding rows with preceeding rows year.

aihnen_0-1573663789160.png
AmeliaG
Alteryx
Alteryx
Spoiler
21_screenshot.png
razziagafur
Alteryx
Alteryx

Getting from one letter months to named months is the part I struggled with the most but managed to get there using the tile and formula tools.

Elysia1
7 - Meteor
 
avinashsunchu
8 - Asteroid
Spoiler
Solved!
JamesCameron
8 - Asteroid

My effort. A bit simpler than week 20!

 

Spoiler
JamesCameron_0-1574171417742.png
Rags1982
10 - Fireball