Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
MRitter
Employee
Employee

Load excel file based on string in the file name

I have a folder that contains multiple excel files.  Part of the file name will always be consistent and I want to load a set of the files based on this string found in the file name.

For example the file name is 

CGCAHPS Adult__Dimensions __Cal Q3 2019 (July - September).xlsx]

I want the From statement to only load the files that have CGCAHPS Adult in the file name.

I tried *CGCAHPS Adult*.xlsx and that doesn't work.

3 Replies
rafaelattux
Partner - Contributor III
Partner - Contributor III

Just use the * at the end like this :

 

FROM [lib://LIB_NAME/CGCAHPS Adult*.xlsx]

MRitter
Employee
Employee
Author

I tried that and I get an error that it can't open the file.

(Native Path: ***
System error: ***)

rafaelattux
Partner - Contributor III
Partner - Contributor III

Can you insert the code , and print of error and the folder.