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