Update a field in a table

[Anonymous]

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?

[manodwhb · Accepted solution]

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

[Anonymous]

Thanks for your support!!!