Loading multiple files in Qlik Cloud

[anushka_iconresources]

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

[SunilChauhan]

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?

[anushka_iconresources]

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]

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.))

[sitemasdipac]

Buenos Dias,

Por favor indicar si solucionaron esta novedad..

Gracias

[anat]

For each File in FileList('$(vFileName) & '\*' & '.csv')
   trace $(File);
   Load * From [$(File)] (txt, codepage is 28591, embedded labels, delimiter is ';', no quotes);
Next File

[marksouzacosta]

I don't think you can do that since this is not a regular Windows folder where you can use wild characters. 
You have to enter the names manually or I maybe there is some short of metadata feature where you can list the file names inside your SharePoint.

[TauseefKhan]

Hi @anushka_iconresources 
Use a loop to iterate through the files.

// Define the file path
LET vFilePath = 'lib://DEV:Office_365_Sharepoint - TEST/Datasource/Care/New Case/Listing/';

// Loop through each file in the directory
FOR EACH vFile IN FileList('$(vFilePath)PatientListing_*.csv')
TRACE $(vFile);
LOAD
*
FROM [$(vFile)]
(txt, utf8, embedded labels, delimiter is ',', msq);
NEXT vFile;