topic How to Execute job row by row in Talend Studio

How to Execute job row by row

vicentef — Thu, 16 May 2019 09:07:01 GMT

Hello guys,

I have a job that gets date from a DataBase (multiple rows) in the DB it is stored the path of a directory (each row in the DB corresponds to a directory). For each row i want to copy the directory, then delete it and last but not least update the database. I want to do that row by row and not Copy everything, then delete everything and update everything.

I've been using Talend for one week now.

I hope that my problem is clear, if not i will try to give you more information if need it.

Example:

The example above is just a shortcup of my real job. There are some tfilterRow, tJavaRow in the middle

I want to do this : gets row1 -> copy row1 -> delete row1 -> update row1

And not this : gets rows -> copy rows -> delete rows -> update rows

Best regards Vicentef

Re: How to Execute job row by row

Anonymous — Thu, 16 May 2019 14:30:04 GMT

Hi,

Could you please try below method?

Here, we are converting the flow from rows to individual iterations. I believe it will help in your case. I would suggest to go through the help document to get more idea about how the values are being passed in the case of iteration model. There are lot of examples in both help.talend.com and in Talend community.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: How to Execute job row by row

Anonymous — Fri, 17 May 2019 09:52:23 GMT

Try to do this : gets row1 -> copy row1 -> delete row1 -> update row1