topic Re: Looping over a files in Talend Studio

Looping over a files

ankit7359 — Sat, 16 Nov 2024 03:28:26 GMT

Hi Community,

i am trying to design a talend job for which the requirements are -

i have about 20 files_names which are to be loaded on to db, but instead od building a complex job i thought of simpler way. What if we pass the context parameters with file_names dynamically and then write a check condition whether the file_name was passed previously or not and also to check for null file_names. each file_name would iterate over a tloop component and after a iteration it would take the next file name..

I am still not sure how to build or design this job? also how do i write the check condition for file names?

Can anyone help me with this?

Any help,hint etc. would be appreciated.

Thanks,

Ankit

Re: Looping over a files

TRF — Fri, 24 Jan 2020 06:46:50 GMT

Did you check at tFileList?

Re: Looping over a files

ankit7359 — Fri, 24 Jan 2020 06:53:28 GMT

Hi @TRF ,

Thanks for your suggestion,

but what concerns me is the check condition.

How do you suggest i tackle it?

Thanks,

Ankit

Re: Looping over a files

TRF — Fri, 24 Jan 2020 07:14:35 GMT

If you want to avoid to process the same file twice when your job start again, rename or move it as soon as it has been processing using tFileCopy. This is the simplest solution.