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 #193: Unofficial Holidays

Bobbiconway
8 - Asteroid

Spoiler

mceleavey
17 - Castor
17 - Castor

Did this while training @FionaRyanWMT !

 

Spoiler
Nice and simple. Converted the "day" column to a date, sorted ascending by date, renamed the columns.

mceleavey_0-1656939180218.png
mceleavey_1-1656939336022.png

 


 

M.



Bulien

FionaRyanWMT
5 - Atom
Spoiler
193.jpg

- Removed leading and trailing whitespace using data cleansing tool
- Parsed Date
- Sorted data ascending to order data in date order
- Used select tool to remove unrequired columns and renamed column headers

Done :-)

finners37
7 - Meteor

I thought this was straight forward, but I did doubt myself!!!

tanyafischer
8 - Asteroid

solved :)

tfviola
6 - Meteoroid

spoiler

toriastahl
6 - Meteoroid

good practice!

chinu267
8 - Asteroid

Solution is below:

 

chinu267_0-1657694818241.png

 

 

 

Alteryx_AR
12 - Quasar

@AYXAcademy My solution.

caoimhebrennan
5 - Atom

My solution