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

TonyA
Alteryx Alumni (Retired)

Had a little fun with this one. Made it general purpose so that with a tweak to the inputs it could accept any number of holiday files and an arbitrary number of Employee/Region pairs in an employee file. Did this with a macro first then realized there was an easier way.

Spoiler
2020-12-28_13-07-03.png
NZP
7 - Meteor
Spoiler
 
dsmdavid
11 - Bolide

 

No filters

Spoiler

Generate rows for weekdays onlyGenerate rows for weekdays only248_output.pngBlue = both, Red = US, Green = AUS

 



RichoBsJ
11 - Bolide

Hi! Here my solution 🙂

 

Thanks @Tony_Castillo 

 

Spoiler
challenge_248.png
Qiu
20 - Arcturus
20 - Arcturus

This is an easy one? So we dont have a hard time for the new year?😁

 

 

challenge_248.PNG

mike_w
8 - Asteroid

Happy New Year!

Spoiler
mike_w_0-1609198908564.png

 

ArtApa
Alteryx
Alteryx

Here is my solution:

 

Spoiler
ArtApa_0-1609200020861.png

 

mbogusz
9 - Comet
Spoiler
Challenge #248 in the canChallenge #248 in the can
AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

Spoiler
AkimasaKajitani_0-1609204801655.png

 

Bonus

Spoiler
AkimasaKajitani_1-1609204821368.png

 

kelvin_law1
9 - Comet

Here is my workflow:

Spoiler
kelvinlaw_0-1609205681590.png