Fetch file basis date available in FileName on WorkingDays

[Shaaz]

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.

[binuacs]

@Shaaz use the directory tool to read the files then sort based on the creation date field in descending order, use the sample tool to read the first record, which will be the latest file which you wanted process 

[Shaaz]

No, I'll receive both the files on the same day.

[binuacs]

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

[binuacs]

@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 

[binuacs]

@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.