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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out 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.