Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #21: Date Reformatting

Highlighted
Asteroid

Here is my take.

 

Spoiler
bjkay30_0-1575573877215.png
Highlighted
Alteryx
Alteryx
Spoiler
Done !
Stéphane Portier
Sales Engineer
Alteryx
Highlighted
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. 
Highlighted

look at me learning regex!

Spoiler
sonyakasenkramer_0-1576173435376.png
Highlighted
Meteor
 
Highlighted

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

Highlighted
Meteor

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

Spoiler
21.PNG

Highlighted
Asteroid
 
Asteroid
Spoiler
Chantelbbr_0-1577143475938.png
Highlighted

Challenge #21 Solution