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 Alumni (Retired)

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