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: DateTopic17-SepWorking Date20-SepHoliday21-SepWorking Date22-SepWorking Date23-SepHoliday24-SepWorking 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 Date.yxmd

Holiday Date Filter

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

Date.yxmd

Join

Preparation

Accepted answers

atcodedog05

Hi @AshishAgarwal

Does this work for you.

Workflow:

Hope this helps : )

Date (2).yxmd

All comments

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

Sure

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 : )

Prev Working day.yxmd

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

Date_example.yxmd

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235