Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Maybe this is helpful: Native SFTP connector and FileList() - Qlik Community - 2453097
Maybe this is helpful: Native SFTP connector and FileList() - Qlik Community - 2453097