Input Wildcard Cannot Find Path

[msarmiento]

Hi,

I have a large number of excel files in a sharedrive location and continue to add new files each month. I need to read all files using wildcard. All files are saved in the same folder and follow the same schema. I am able to select 1 file and have no trouble inputting the data but as soon as I replace the file name with the adjusted * for a wildcard search, I get an error message saying that the path cannot be found:

Path for single file: 

\\fs\SouthPublic\Groups\Qlikview Reports\FY24-25 Qlikview Report\PNS 2024-01 QlikView.xlsx

Note: when setting up the connection for a single file, I do have to change the file type to Microsoft Excel Legacy (.xlsx) to find the desired files. 

Adjusted path for wildcard.

\\fs\SouthPublic\Groups\Qlikview Reports\FY24-25 Qlikview Report\QlikView*.xlsx

Note: All files contain "Qlikview" in the name 

Need ideas on how to troubleshoot. Could the issue be the file type?

[alexnajm · Accepted solution]

"\\fs\SouthPublic\Groups\Qlikview Reports\FY24-25 Qlikview Report\QlikView*.xlsx" is expecting "Qlikview" to only be at the beginning of your file name. If you want it in any part of the file name, you'll need an extra asterisk to signify something could be before Qlikview, something like "\\fs\SouthPublic\Groups\Qlikview Reports\FY24-25 Qlikview Report\*QlikView*.xlsx"

[msarmiento]

Thank you so much! That worked :)