- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Maybe this is helpful: Native SFTP connector and FileList() - Qlik Community - 2453097
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Maybe this is helpful: Native SFTP connector and FileList() - Qlik Community - 2453097