Using wildcard in Data input

[mohit9garg]

Hi,

I have hundreds of excel files in a sharedrive for 2021 and 2022. I need to read all 2022 files using wildcard. Can you please advise how can I use * and ? both in wildcard.

File Name Examples: I need to read only last 2 files.

\\path\abcd_20211201.xlsx

\\path\mnopq_20211205.xlsx

\\path\pqr_20220120.xlsx

\\path\xy_20220210.xlsx

thanks

[atcodedog05]

Hi @mohit9garg 

try this guide https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/t...

Hope this helps : )

[mohit9garg]

@atcodedog05 Can I use * and ?? both in wildcard?

[binuacs]

@mohit9garg  to provide an add on to @atcodedog05  link you can add a sort tool and a filter tool to get the latest file you want

[atcodedog05 · Accepted solution]

Hi @mohit9garg 

Only .* is allowed which means any or no characters

Hope this helps : )

[atcodedog05]

Happy to help : ) @mohit9garg 

Cheers and have a nice day!