Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #21: Date Reformatting

Highlighted
Meteoroid

I wondered if there is a way to change Month names without writing the amount of "IF's" used in the main solution.

If someone did it - please let me know :)

Highlighted
Asteroid

👍

Highlighted
Asteroid

I really enjoyed this one. Understanding all of the problems/requirements was the key for me in solving this one. Plus I learned the extra utility of a tool I use infrequently.

Highlighted
Meteor

I actually had this as the solution but spent quite a bit of time trying to do something different.

 

I did like the input table from someone as a conversion. Great Idea.

Alteryx Partner

My first challenge! I'm looking forward to getting stuck in with these to improve my Alteryx skills. I'm sure there's a more efficient way to do the calcs, but it worked!

Spoiler
Screenshot 2019-03-13 at 8.12.31 am.png
Highlighted
Alteryx Partner

sort of an easy one for me so I tried a few different things here

Highlighted
Asteroid
 
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Some fun regex in this one (Y)

 

Spoiler
2019-03-14_16-16-05.png
Highlighted
Meteor

A suggested solution

Highlighted
Asteroid

Feels far too manual but got there in the end..

 

EDIT: ah, just thought of a much better way! attached.