Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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
7 - Meteor

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
7 - Meteor

It was pretty cool approach. I learnt from this.

Raphael_Ar
7 - Meteor

Here's my solution!

Spoiler
ara_rapha_0-1621498461187.png

 

RashedDS
8 - Asteroid

My solution for week 21

 

Spoiler
week21.JPG

 

apathetichell
18 - Pollux

this exercise is more fun with regex.

Jonny
11 - Bolide

My solution:

TKSnider
8 - Asteroid

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
6 - Meteoroid

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
7 - Meteor

.

ShashankRaj12
8 - Asteroid