Fetch file basis date available in FileName on WorkingDays

Question

Hi Team,

How to fetch data from File basis below condition.

Scenario1: WD1 to WD8 (Mar'23)

I'll get Files of previous month (Feb'23)

Lets say on WD1, I received file of 28th Feb'23 and also 1st Mar'23. Here I've to select 1st Mar'23 file only

FileName: Details_28022023.xlsx ; Details_01012023.xlsx

How to select Details_01012023.xlsx file when running workflow on WD1.

Scenario2: >=WD9 (Mar'23)

I'll get Files of current month (Mar'23)

Lets say on WD9, I received file of 10th March and also 13th Mar'23. Here I've to select both the files

FileName: Details_10032023.xlsx ; Details_13032023.xlsx

How to select Details_10032023.xlsx ; Details_13032023.xlsx file when running workflow on WD9.

binu_acs · Answer

@Shaaz Alsso for the second scenario do you see any issues using the directory tool and processing the files at once

Scenario2: >=WD9 (Mar'23)

I'll get Files of current month (Mar'23)

Lets say on WD9, I received file of 10th March and also 13th Mar'23. Here I've to select both the files

FileName: Details_10032023.xlsx ; Details_13032023.xlsx

How to select Details_10032023.xlsx ; Details_13032023.xlsx file when running workflow on WD9.

binu_acs · Answer

@Shaaz I was talking about the below approach for the WD1 to !D7 workflow.

You should use the directory tool to get all the files and extract the date from the file name

FileName_220323.yxmd

binu_acs · Answer

@Shaaz in that case extract the date from the file name and filter the max dated file