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

Kakuffo
Alteryx
Alteryx

Multi Row formula

Snare
8 - Asteroid
Spoiler
Snare_0-1574712298164.png
Nic_Morales
Alteryx
Alteryx

Solution attached. 

Hezabel
6 - Meteoroid

my solution involved transforming into date format in order to get the month as a Mon format.  My main learnings when doing this - leave everything as a string before using the DateTime tool.  I'm guessing you could probably do this as steps in a formula

danicahui
8 - Asteroid
Spoiler
Challenge 21 2019-11-29.jpg
Normster
8 - Asteroid

I created all the months in the Formula tool instead of with the Multi-Row tool like the solution.  It was a little cumbersome at the time but looking at the code in the Multi-Row tool, it seem so bad.  Of course, this was a small data set.

 

Norm

ozdogand
8 - Asteroid

here you go..

 

Spoiler
I added a mapping table that lists the months in order.  
ozdogand_0-1575354266728.png
saikiranvvn
5 - Atom

Spoiler Alert

workflow.PNG

serenahandel
6 - Meteoroid
Spoiler
serenahandel_0-1575483011971.png
jfone
8 - Asteroid