Transform Map create duplicates

[Anupam Thomas]

Hi all,

I am searching for a way to prevent transform map to create duplicates in the Switch Table. Please suggest me a way in which this can be accomplished. Kindly share any docs/ materials related to this requirement that you might know. 

Thank you.

[Community Alums]

Hi @Anupam Thomas ,

Hi, in your transform you will need to set coalesce to true for the field combination that makes the record unique IE 'user name, publisher, product and last used date'

If these values are not available directly from your data you can use a 'field map' source script to derive suitable value for the field(s)

Create a field map (servicenow.com)

or you can utilize a before transform script to process each row in your record set and decide to insert\update\abort as required.

Transform Event Scripts | ServiceNow Developers

[Gayatri Sharma1]

Hi @Anupam Thomas 
Have you checked the coalesce checkbox for the unique field that will make the record unique and help to avoid duplicate records?