Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Congrid
Contributor III
Contributor III

Load from multiple csv files using wildcard from SFTP data connection in SaaS

I have created a SFTP data connection in Qlik Sense SaaS and I am able to load data from a single file present in the SFTP folder.

Now, I want to load the data from all the .csv files present on the FTP path using wildcard but when I do that I get an error: "Connector error: Not found"

Here is the code snippet:

===========================================================

SET vIndex = 1;

FOR EACH file in FileList('Lib://:SFTP_connection/ToClient/Test-QlikSaaS/*.csv');

IF vIndex = 1 THEN

Data:
LOAD
*
FROM $(file) (txt);

ELSE

Concatenate(Data)
Load *
From $(file) (txt);
ENDIF

LET vIndex = vIndex + 1;

Next

=============================================

Any suggestions?

Labels (2)
1 Solution
1 Reply