Holiday Date Filter

[AshishAgarwal]

Please help to figure out below.

I have list of input data file for many days of 2021.

I need to pick up data of Holiday date till last working day.

For ex:

Date	Topic
17-Sep	Working Date
20-Sep	Holiday
21-Sep	Working Date
22-Sep	Working Date
23-Sep	Holiday
24-Sep	Working Date

I need to pick up only 23rd Sept date file when I am running workflow for 24th Sept.

I tried working out some workflow but I am getting 2 date file of 20th Sept & 23rd Sept.

Please let me know which step i should modify or add to make workflow simple.

Thank you so much

[AngelosPachis]

Hi @AshishAgarwal ,

Maybe you can attach some sample data from the Japan Holiday.xlsx file, as currently we don't have access to that file and the workflows errors at the input tool.

Thanks,

Angelos

[AshishAgarwal]

Sure

[atcodedog05]

Hi @AshishAgarwal 

Is this what you are trying to do calculate prev working day so that you can filter on previous working day.

Workflow:

Hope this helps : )

[AngelosPachis]

Thanks @AshishAgarwal ,

Similar logic to what you've come up with, you can use a generate rows tool to create a list of all days from the COB date all the way back to the first of January for that year. Then with a Join tool, you can find all values that match (they are holidays) and then only keep the most recent with a sample tool

[AshishAgarwal]

Hi @atcodedog05 

Sorry, but not like below

For 24th Sept my previous working day should be 22nd Sept.

Hence I need to pick up 23rd Data & 24th data for my workflow.

I figured out to pick up 24th data but having issue in picking 23rd data.

Regards,

Ashish

[atcodedog05]

Hi @AshishAgarwal 

Sorry about that fixed.

Workflow:

Hope this helps : )

[AshishAgarwal]

Hi @AngelosPachis 

sample tool will pick up only first row but I can have multiple contionous holiday.

For example in May we have holiday from 3rd May to 5th May.

So I have to up data for all 3 holidays.

Hence I cannot put sample.

Regards,

Ashish

[atcodedog05]

Hi @AshishAgarwal 

Are you looking for something like this.

Workflow:

Hope this helps : )

[AshishAgarwal]

Hi @atcodedog05 

Sorry, I might not have informed correctly.

I will run workflow for 24th Sept and I have list of Japan Holidays file.

From that I have to figure out holiday date preceding workflow date. 

Below data is only for explanation here. I will not have such data in my workflow.

I have reattached my workflow.

Sorry for taking so much time.