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
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)
