Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
Start Free Trial

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

arpit_tyagi
Meteoro

New to Alteryx and Hello from India

 

Tried my bit. Solved this with a different angle and found that it is different from the main solution

 

This is my first challenge here in Alteryx  and I found out one thing that challenges never get old.

 

arpit_tyagi
Meteoro

It was pretty cool approach. I learnt from this.

Raphael_Ar
Meteoro

Here's my solution!

Spoiler
ara_rapha_0-1621498461187.png

 

RashedDS
Asteroide

My solution for week 21

 

Spoiler
week21.JPG

 

apathetichell
Arturo

this exercise is more fun with regex.

Jonny
Bólido

My solution:

TKSnider
Asteroide

I'll be honest, I fought with this one for a few.  I just didn't want to believe it would be that straight forward 🙂

 

My solution is below.

mattjacobs
Meteoro

I took a different approach than the posted solution.  I split the dataset using sampling tool, 1st 12 and last 12 records, added a record id that matched the month number (1=Jan, 2=Feb, etc.).  Used the lookup table to populate the MMM value and then a formula tool to add the year.  Then unioned the two data streams back together.

bam
Meteoro

.

ShashankRaj12
Asteroide