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
Solved! Go to Solution.
Hi @mohit9garg
try this guide https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/t...
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
Happy to help : ) @mohit9garg
Cheers and have a nice day!