How to fill date gaps? Holiday and weekend

Joker_Hazard

Hi!

I need to fill the last date gap within my workflow. The premise of my automation is to analyze the data of previous working date.

So, I need to:

1. If today is monday, the last available data is from friday, then copy paste friday data to saturday and sunday.
2. If today is monday, the last available data is from thursday (because friday is holiday), then copy paste friday data to saturday and sunday.
3. If today is wednesday, the last available data is from monday (because tuesday is holiday), then copy paste monday data to tuesday.

I created an auxiliary table with all weekend and holiday dates to help me out, but I cannot think of a way to do this. Anyone has any ideas?

There's also a sequence o two holidays in a row. (that could happen)

Dummy Workflow.yxmd

Dummy data.xlsx

Weekend and holiday dates.xlsx

Joker_Hazard

Hi Trieger!

Thanks for the comment. I have something in mind but I cant find a logic to do it. Because if the previous date is not a holiday or a weekend, it should follow as it is.

I am trying for a few days, but no success. Its been a while since I used alteryx, just returned to the platfaorm