Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #21: Date Reformatting

Highlighted
Alteryx
Alteryx

Multi Row formula

Highlighted
8 - Asteroid
Spoiler
Snare_0-1574712298164.png
Highlighted
Alteryx
Alteryx

Solution attached. 

Highlighted
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

Highlighted
8 - Asteroid
Spoiler
Challenge 21 2019-11-29.jpg
Highlighted
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

Highlighted
Alteryx Partner

here you go..

 

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

Spoiler Alert

workflow.PNG

Highlighted
6 - Meteoroid
Spoiler
serenahandel_0-1575483011971.png
Highlighted
8 - Asteroid