Using wildcard in Data input

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

Input

Accepted answers

Only .* is allowed which means any or no characters

Hope this helps : )

All comments

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

Hope this helps : )

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

@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

Only .* is allowed which means any or no characters

Hope this helps : )

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703