Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
iamabhishek
Creator III
Creator III

SFTP multiple files using tFTPPut

Trying to build a solution to transfer files to an FTP server from local on-premise system. Currently the process is only transferring the last file of the lot found from the directory. Tried debugging the job but couldn't understand where the actual problem is. 

What I have tried so far:

Used tFileList to get the list of files for a given directory, given "*.txt" as FileMask.

Used tIterateToFlow to iterate through the list of files. The Schema is of a single column "fileName" with the value set as - ((String)globalMap.get("tFileList_1_CURRENT_FILE"))

Finally used tFTPPut to SFTP the files to remote directory. Local Directory is set as - ((String)globalMap.get("tFileList_1_CURRENT_FILEDIRECTORY")) & FileMask as - ((String)globalMap.get("tFileList_1_CURRENT_FILE")). Overwrite is the option chosen.

Screenshot of the job -

tFTP-1.JPG

Thanks in advance for any kind of help and let me know if more information is required for this.

Platform: Talend Open Studio for Data Integration Version: 6.5.1

Labels (2)
11 Replies
manodwhb
Champion II
Champion II

@iamabhishek,please accept solution.

iamabhishek
Creator III
Creator III
Author

Thanks for the explanation, makes sense now.