AnsweredAssumed Answered

Check if some key fields in table have changed. If so when updating the record also mark a field called ActFlag to "Update".

Question asked by gouthamr388096 on Nov 3, 2016
Latest reply on Nov 7, 2016 by Srinivas Chandrakanth Vangari

Hi Folks,

I have a process where I have to check to see if a record exists in a table. I am using decision shape to check for existence of the record. If it exists I update the record. If not I insert a record.

When I update the record, before updating I have to get few fields in teh table and store them somewhere. After that I have to check if the values for those fields in the table and the values that are now coming in are same or different. If they are same, I will have to update the record but also mark a field called ActFlag to "None". If they are different, update the record and also in the ActFlag field insert "Update".

What is the best way to achieve this?