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.
We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.

Weekly Challenge

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

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

Submit Feedback

Challenge #248: Holidates

KilianL
Alteryx
Alteryx

Aiming for the simplest solution I can come up with.

 

Spoiler
1. generate business days
2. add Holidays

248 - Holidates - Kilian.png
JosephSerpis
15 - Aurora
15 - Aurora

Challenge Completed

 

Spoiler
Weekly_Challenge_248_Macro.JPG
A2H
11 - Bolide

A simple solution happy to share.

 

Spoiler
Capture d’écran, le 2021-01-12 à 14.43.35.png

 

 

sonnenthaler
6 - Meteoroid

Here is my solution. Second challenge ever so far. I start to like them 🙂

 

Spoiler
sonnenthaler_0-1610530020504.png

 

 

Didier
5 - Atom

The solution is good and I do like the "Join Multiple".

 

I would propose though a solution based on a join able to handle any number of regions. I'm not sure it's leaner as I've not seen the point changing the date format...

 

Happy holidays to all !

May the "data" be with you !

Didier.

DataTester
8 - Asteroid

Solution attached

byagelski
8 - Asteroid

solved.  introducing the find and replace tool instead of the join caused me to have to change the dates to strings but i still like using the tool instead of join in those situations.

JRODCR
6 - Meteoroid

My Solution

Sash
7 - Meteor

Solution

PaulineB
7 - Meteor

🙂