Transform map to avoid insert if record matches

[Swati k1]

Hi All,

during dataload , we want to ignore insert record if the same record already existing in table , which way can we ignore inserting record ?can we update reject in choice action or need to write transform script?

[Musab Rasheed]

Identify unique field and make ceolace as true that will do that job. In you case if unique field is u_file_id and this is not reference then make colace as true or else reject choice action has to be there in case if it is reference field. Give a try.

[Swati k1]

ceolace field make new records will be get override on existing records if those matches.

We need to ignore if those record matches.. please suggest 

[Anil Lande]

Hi,

You can use onBefore transform script and check operation. Use below logic:

  if (action == 'update') {
    ignore = true;
  }

Thanks,

Anil Lande

[Anil Lande]

To learn more you can check below course on developer portal.

https://developer.servicenow.com/dev.do#!/learn/learning-plans/quebec/new_to_servicenow/app_store_le...

Thanks,
Anil Lande