Dynamic pick file for input and Process

[aman_goyal]

Hi Team,
Suppose we have multiple files with different columns (structure) that are in sub-folders. I want that user select date from calendar and according to that date pick files from that folder and process.
Example:
We have folder structure like-
Input Files-30-09-2021- XYZ-policy.xlsx
Input Files-30-09-2021- XYZ-superstone.xlsx
Input Files-30-09-2021- PQR-furniture.xlsx
Input Files-31-12-2021- XYZ-policy.xlsx
Input Files-31-12-2021- XYZ-superstone.xlsx
Input Files-31-12-2021- PQR-furniture.xlsx

When I select date 30-09-2021 from calendar then it will pick the folder 'Input Files-30-09-2021' and then corresponding files will be taken as input.

Suppose for  first input tool policy.xlsx file and for 2nd input tool  furniture.xlsx file should come.

I tried this way-

This is working but for every file I have to add filter tool and dynamic input tool. Is there any other w

Can you please help me how I can implement this?

[afv2688 · Accepted solution]

Hello @aman_goyal ,

You can do that simply by using an action tool configured like this:

'C:\Users\SOMEPATH\*' + DateTimeFormat([#1], '%d-%m-%Y' ) + '*.xlsx'

Try it out and let me know.

Regards

[aman_goyal]

Thank You @afv2688 . It works for me.