ts3List to file input excel

Six Stars

ts3List to file input excel



 Would like to ask if there is a way to get the file dynamically from ts3list iterate to inputfileexcel then put it on redshift. Is there other way by doing it. I encounter this error while running the jobs. Kindly see the image



Community Manager

Re: ts3List to file input excel

The file should exist local system where the job is executed, so you need to download the file from S3 to local system first, eg:
tS3list--iterate-tS3get--oncomponent-->tfileinputExcel--tmap--tRedshiftOutput--oncomponent--tFileDelete (delete the file from local system if needed)

Hope it helps!


Talend | Data Agility for Modern Business