alteryx Community

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.

Challenge #21: Date Reformatting

8 - Asteroid
Spoiler

A bit of a brute force strategy I think, but I got it. Fun challenge!

8 - Asteroid

Solution Attached

8 - Asteroid
Spoiler
8 - Asteroid
Spoiler

8 - Asteroid

Solution

8 - Asteroid

here is my solution

6 - Meteoroid

1. Formula 1: Left([Date], 1)

Formula 2: IF Length([Date]) >2 THEN Right([Date], 2) ELSE "" ENDIF

2. Multi-Row Formula for the Year column: IF IsEmpty([Year]) THEN [Row-1:Year] ELSE [Year] ENDIF

3. Multi-Row Formula to create a month number/count column: [Row-1:Month number]+1

4. Switch function to replace numbers with month abbr: Switch([Month number],Null(),1,'Jan',2,'Feb',3,'Mar',4,'Apr',5,'May',6,'Jun',7,'Jul',8,'Aug',9,'Sep',10,'Oct',11,'Nov',12,'Dec')

5. Select tool to hide a month number/ count column

8 - Asteroid
Spoiler

7 - Meteor

solution

10 - Fireball

Solution Attached !!