How can I update the target table records by using MRVSet in record producer

[msc]

Hi @Ankur Bawiskar ,

How can I update the target table records by using multi row variable set in record producers. 

Let say for every record in MRVSet if matching record in Target table is found then I have to update it else new record will insert by using record producer.

Is it possible to do that , please help me on this.

[Tony Chatfield1]

Hi, in your producer script I think you would want to loop through the contents of the variable set, and for each row/group of variables looking up each related record using GlideRecord and update the record (assume this is from other variables in the row).

if you do not want to 'insert' a new record from the record producer at the end of your script you would need to abort the action using current.setAbortAction(true);

[Mark Roethof]

Are other people than Ankur also allowed to reply 😂
I'll just keep a good answer for your question in my pocket in the meanwhile.

[msc]

Hi Mark, 

Please help me on this.

[Ankur Bawiskar]

@msc 

you can use flow designer or business rule on the target table of record producer.

what approach did you start with and where are you stuck? what debugging have you done so far?