topic Re: Update a field in a table in Talend Studio

Update a field in a table

Anonymous — Sat, 13 Jun 2020 12:20:46 GMT

Hi,

I have a process to detect changes if any field has changed, in case the data of a row has changed, I would like to update a field called Status to 0, because then I write a new record with new data with this valur to 1.

How can I update a field from source table to target table?

Re: Update a field in a table

manodwhb — Sun, 14 Jun 2020 00:35:47 GMT

Do the look-up on key and then you compare the fields like below and update the table.these all thing you can do in tMap.

Row1.col1.equals(row2.col1) && row1.col2.equals(row2.col2)?1:0

Re: Update a field in a table

Anonymous — Wed, 17 Jun 2020 08:20:11 GMT

Thanks for your support!!!