Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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

DataKyle
8 - Asteroid

I always enjoy going through these challenges as they provide a chance to utilize tools that are less common for me to have a need for.

rslopez2
8 - Asteroid

Used slightly different Tools but overall same approach as provided Solution 🙂

 

- Used Multi-Row Formula to get month Numbers based on date Length (loved solution provided nested formula to achieve this with simple the formula tool!)

- Used Formula to convert Int values to 3 letter Month 

- Used Multi-Field Formula to Populate current year based on if it was first month

- Used Multi-Row Field to Populate correct year across all Rows

- Select to Rename and drop unnecessary Fields 

 

Spoiler
RL_challenge_21.png
rcor
8 - Asteroid
Spoiler
challenge_21_RC_solution.PNG
ocasey
6 - Meteoroid

A bit different, same result

Cumminsj2
7 - Meteor
 
Sihlex1
7 - Meteor
 
MartinStraech
8 - Asteroid

Felt like this was one of my uglier solutions. I still need to get more proficient with the multi row formula tool.

 

Spoiler
SolutionClipping.PNG
PaulN
Alteryx Alumni (Retired)
 
Marcel_Gavrila
8 - Asteroid

Here's my solution with only 2 tools 🙂

Spoiler
Capture.JPG
bnelly1987
8 - Asteroid

Kind of ugly but it works

Spoiler
Solution-Challenge 021.PNG