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

msc
Tera Contributor

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.

 

5 REPLIES 5

Hi Ankur,

Yeah so here we have one custom table called it as Customer account table.

In custom table based asset field and account table filed value , I just auto populated the mrvs values.

In that mrvs columns are tag field, start and end date fields is there.

If I update the above fields.

Once submit the record producer how can I map these fields in to target table records by using script or script include. Please help me on this.