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

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