Hello,
I'm trying to see if the process that I apply in my file using Power Query is possible in Alteryx so here's my scenario.
What I use to do in Power Query is create a tab for ReportMonth (format: mm-yyyy) so it will automatically look up the specific file inside a folder with the same month given that it has same date format (mm-yyyy) and will load that file into my main sheet.
Sorry if my explanation is a bit complicated..
Thanks,
Ryan Esmalin
@rjesus1925
If my understanding is correct, you only want to bring in the file with specific date, and ignore other files in the same folder?
In the Data Input tool, we can use the wild card "*" to match your date in the file name.
Is this what you need?