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.