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
Solved! Go to Solution.
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
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 : )
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
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
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
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.