Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #21: Date Reformatting

Highlighted
6 - Meteoroid

Solution: 

 

NichWhit_0-1596224891859.png

 

Highlighted
6 - Meteoroid
Spoiler
ZLavasque_0-1596225038273.png

 

Highlighted
8 - Asteroid

Sometimes without context it hard to know what solutions will work... I made the assumption that all months will be present (as the solution also need to look at adjacent rows)... and made an alternate solution.

Highlighted
9 - Comet

My solution.

 

Spoiler

bmcclelland46_0-1596640685788.png

 

Highlighted
8 - Asteroid

my solution

Highlighted
8 - Asteroid

Done ! 

Highlighted
7 - Meteor

Completed

Highlighted
Alteryx Partner

solved using Formula Tool string manipulation and multi-row formula tool then joining on a month mapping table

Highlighted
7 - Meteor

Date with IF statement reformatting are definitely a bit challenging for me.

Highlighted
9 - Comet
Spoiler
Annotation 2020-08-08 233219.jpg