topic ts3List to file input excel in Talend Studio

ts3List to file input excel

Anonymous — Thu, 26 Jul 2018 09:11:25 GMT

Hi,

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

Re: ts3List to file input excel

Anonymous — Thu, 26 Jul 2018 10:50:52 GMT

Hi
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!

Regards
Shong