Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
anushka_iconresources
Contributor II
Contributor II

Loading multiple files in Qlik Cloud

Hi Everyone,

 

I am trying to load multiple files in Qlik cloud using the following format from Sharepoint Connection

"FROM [lib://DEV:Office_365_Sharepoint - TEST/Datasource/Care/New Case/Listing/PatientListing*.csv]
(txt, utf8, embedded labels, delimiter is ',', msq);"

File name is PatientListing_DDMMYYYY, and i would like to load all the files.

Can someone please suggest a way to load all these files at once.

Regards

 

Labels (2)
3 Replies
SunilChauhan
Champion II
Champion II

try with underscore

"FROM [lib://DEV:Office_365_Sharepoint - TEST/Datasource/Care/New Case/Listing/PatientListing_*.csv]
(txt, utf8, embedded labels, delimiter is ',', msq);"

 

or share the error message?

Sunil Chauhan
anushka_iconresources
Contributor II
Contributor II
Author

Still giving error with underscore
 
Cannot open file: 'lib://DEV:Office_365_Sharepoint - TEST/Datasource/Care/New Case/Listing/PatientListing_*.csv' (Connector error: Failed on attempt 1 to GET. (-2147024894, System.IO.FileNotFoundException, File Not Found.))
anushka_iconresources
Contributor II
Contributor II
Author

Still Giving error with underscore

Cannot open file: 'lib://DEV:Office_365_Sharepoint - TEST/Datasource/Care/New Case/Listing/PatientListing_*.csv' (Connector error: Failed on attempt 1 to GET. (-2147024894, System.IO.FileNotFoundException, File Not Found.))