Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

IgnasP
6 - 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 :)

IJReed
8 - Asteroid

👍

AmNotARobot
8 - 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.

dpcurtis
7 - 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.

vizwiz
5 - Atom

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
joshuaburkhow
ACE Emeritus
ACE Emeritus

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

Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
RobertOdera
13 - Pulsar
 
BenMoss
ACE Emeritus
ACE Emeritus

Some fun regex in this one (Y)

 

Spoiler
2019-03-14_16-16-05.png
mambo
7 - Meteor

A suggested solution

Benbryans
8 - Asteroid

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

 

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