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

bjkay30
8 - Asteroid

Here is my take.

 

Spoiler
bjkay30_0-1575573877215.png
StephaneP
Alteryx
Alteryx
Spoiler
Done ! 🙂
Stéphane Portier
Sales Engineer
Alteryx
Hjardine
8 - Asteroid

Hjardine_0-1576102602689.png

Spoiler
Used tile tool with the equal records method. Used 2 as number of tiles so i'd have 2 separate sequences of 1-12 for each month. This also gave me 2 tile numbers, 1 if it was in 2007 and 2 if it was in 2008. Then used a formula to replace each number with its corresponding month (i.e. 1 is Jan, 2 is Feb, etc.). Pulled in another formula to combine 0 with the tile number plus 6, which came out to "07" in 2007 and "08" in 2008. Finally a select tool to match output. 
sonyakasenkramer
8 - Asteroid

look at me learning regex!

Spoiler
sonyakasenkramer_0-1576173435376.png
mcazare
7 - Meteor
 
Nicholas_Bignell
8 - Asteroid

Took a break from Challenge 20 to attempt this one and give my brain a breather!

Ivyin702
7 - Meteor

Learn very useful tools this time: RegEx and Multi-Row formula

Spoiler
21.PNG

rmassambane
10 - Fireball
 
Chantelb
9 - Comet
Spoiler
Chantelbbr_0-1577143475938.png
AngelosPachis
16 - Nebula

Challenge #21 Solution