Multiple input file get from a specific folder automatically

Anjankumar2021

i want to get below input files automatically to my 3 input tools from particular directory.

everyday file date will change for input files and we have fixed file names ( Desktop, Designer 1 and Designer 2)

Input :

File Name 1 : Desktop as of 02.05.2024

File Name 2 : Designer 1 as of 02.05.2024

File Name 3 : Designer 2 as of 02.05.2024

Output:

Input tool 1: Designer 1 as of 02.05.2024

Input tool 2 : Designer 2 as of 02.05.2024

input tool 3:Desktop as of 02.05.2024

Workflow

Accepted answers

aatalai

use the directory tool and the filter on the file name with the following expression

contains ( [filename], datetimeformat(datetimenow(),"%d.%m.%Y"))

LEt me know how you get on

All comments

aatalai

use the directory tool and the filter on the file name with the following expression

contains ( [filename], datetimeformat(datetimenow(),"%d.%m.%Y"))

LEt me know how you get on

Anjankumar2021

@aatalai its working fine for two input tools but third one its throwing Dynamic input tool error.

Alteryx does not match a sheet or named range . the file is corrupted .i have checked no white space or path issue or spelling mistake. not able to find issue when iam using sheet 3. but i noticed that when change sheet name(Sheet 3 to Sheet 4) its working .

sheet names:

Sheet 1 : Sales

Sheet 2: Region

Sheet 3: discount

Sheet 4: Model

aatalai

try a batch macro instead of a dynamic input tool

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703