ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start 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

ncrlelia
11 - Bolide
‎07-09-2021 10:33 PM

Challenge 193

Challenge 193.yxzp
Reply
Erin
11 - Bolide
‎07-13-2021 09:04 AM
Spoiler
BronzeFox_0-1626192251376.png

 

challenge_193_submission_EM.yxzp
Reply
0 Likes
siddharth_28
8 - Asteroid
‎07-13-2021 11:12 AM

Re: Challenge #193: Unofficial Holidays

challenge_193_solution.yxzp
Reply
0 Likes
JackBurnham
8 - Asteroid
‎07-14-2021 01:54 AM

b

challenge_193.yxmd
Reply
0 Likes
euanwilson
8 - Asteroid
‎07-14-2021 01:59 AM
Spoiler
Workflow.PNGResults.PNG
challenge_193_euanwilson.yxmd
Reply
0 Likes
Jonny
11 - Bolide
‎07-15-2021 05:38 AM

my solution:

 

Spoiler
DateTimeParse always win for figuring out "unusual" date formats. Found out as well that if you do not define a year Alteryx defaults to 1400! I wonder why this year?

Jonny_2-1626352636748.png

 


Results:

Jonny_1-1626352584287.png

 

 
challenge_193_Jonny.yxmd
Reply
0 Likes
KyronSmith
7 - Meteor
‎07-15-2021 06:46 AM

I might have to keep this file to keep track of all the national days!

challenge_193_start_file.yxmd
Reply
0 Likes
sbarton
8 - Asteroid
‎07-19-2021 08:06 PM

My solution

Shaun Barton challenge_193_solution.yxmd
Reply
0 Likes
joelmiller66
9 - Comet
‎07-20-2021 04:55 PM
Spoiler
Challenge 193 Image.png
challenge_193_AB Data_Joel.yxmd
Reply
0 Likes
Elias_Nordlinder
11 - Bolide
‎07-22-2021 12:00 AM

Nice and quick one 🙂

 

Spoiler
Elias_Nordlinder_0-1626937206303.png

 

Weekly_Challenge_193_EN.yxmd
Reply
0 Likes