Six Stars

ts3List to file input excel

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

 

 

1 REPLY
Community Manager

Re: ts3List to file input excel

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

----------------------------------------------------------
Talend | Data Agility for Modern Business