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

🙂