I want to built a job which looks up in the sftp folder for different excel files and downloads it to the local directory and executes a python script to them one by one and finally moves them to the archive. For this purpose I have created a job as in the screenshot. (Please ignore connection2: its for streaming purpose)
I am very new to Talend. When I run the job. It just executes one file from 3 of them and leaves the two untouched. I would like the job to look for multiple files and download it to the local folder and if the file already exist in local folder and sftp, just execute the script on the next excel after downloading it. Can anyone give me some hint, how this would be possible. Thank you so much