In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!
Free Trial

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

mmkisaac
8 - Asteroid

193 Complete

Sashikumar
8 - Asteroid

It's Fun one.

Spoiler
ch193.PNG
jamielaird
14 - Magnetar

Here's my solution:

 

Spoiler
jamielaird_0-1600688907898.png

 

JethroChen
10 - Fireball
Spoiler
challenge_193_jc.PNG
mulvihi11
8 - Asteroid

Quick, fun challenge! Didn't know two holidays fell on my birthday!

Spoiler
mulvihi11_0-1600950045226.png

 

ehughes
9 - Comet

My solution

Spoiler
ehughes_0-1601048227459.png

 

bjkay30
8 - Asteroid

Quick and easy one...

 

Spoiler
bjkay30_0-1601474140598.png

 

ashishabhishek
7 - Meteor

my solution  @Samanthaj_hughes 

LukaszKarpinski
8 - Asteroid
Spoiler

Łukasz_0-1601620864802.png

 

rajatsadan
8 - Asteroid

@AYXAcademy Interesting challenge!!

Went through the solution provided and found out I arrived my solution with just 4 tools in the workflow!

Spoiler
Spoiler

I used a combination of DateTimeParse(1) and DateTimeFormat(2) to extract the results in date as well as string format. Then used results from (1) in sort order so that results are sorted in dates instead of alphabetical order. Finally Used the select tool to only include results in (2) in string format to get the Holidays!

 Hope this is also a right way of approach. Thanks!!