Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
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 #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.

スポイラ
2020-12-28_13-07-03.png
NZP
メテオール
スポイラ
 
dsmdavid
ボリード

 

No filters

スポイラ

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

 



RichoBsJ
ボリード

Hi! Here my solution 🙂

 

Thanks @Tony_Castillo 

 

スポイラ
challenge_248.png
Qiu
21 - Polaris
21 - Polaris

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

 

 

challenge_248.PNG

mike_w
アステロイド

Happy New Year!

スポイラ
mike_w_0-1609198908564.png

 

ArtApa
Alteryx
Alteryx

Here is my solution:

 

スポイラ
ArtApa_0-1609200020861.png

 

mbogusz
コメット
スポイラ
Challenge #248 in the canChallenge #248 in the can
AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

スポイラ
AkimasaKajitani_0-1609204801655.png

 

Bonus

スポイラ
AkimasaKajitani_1-1609204821368.png

 

kelvin_law1
コメット

Here is my workflow:

スポイラ
kelvinlaw_0-1609205681590.png