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 #248: Holidates

KilianL
Alteryx Alumni (Retired)

Aiming for the simplest solution I can come up with.

 

Spoiler
1. generate business days
2. add Holidays

248 - Holidates - Kilian.png
JosephSerpis
17 - Castor
17 - Castor

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
6 - Meteoroid

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

🙂