Getting unwanted duplicates from Transform map in ServiceNow table

[Luis Garcia]

Hello everyone
I wanted to ask if you have any solution to my case. I am using Transform maps to pass some data to a certain table in the CMDB in ServiceNow. I put as coalesce the fields "Name" and "IP Address" so that it does not generate duplicates and the "Coalesce case sensitive" checkbox for Name is checked. But as I show in the images (example values), there is data in the document with records that have the same name but are mixed with uppercase and lowercase letters and ServiceNow is not recognizing this, generating new records. Please any help so I can prevent this.

Example Values

busbtsalcts01.cts.hosted.pri             10.163.145.1345

BUSBTSALCTS01.CTS.hosted.pri   10.163.145.1345

[Allen Andreas · Accepted solution]

Hi,

If the case sensitive box is checked, then it's looking for the exact same case...so when it doesn't find it, it's inserting another record.

Please uncheck the case sensitive box as per your requirements that's not appropriate.

Please mark reply as Helpful/Correct, if applicable. Thanks!

[Luis Garcia]

Thanks Allen,
I think I was misunderstanding the functionality of this check-box. So it's not checked anymore and I think that fixed the duplicate record problem.

| Luis |

[Deepti G]

HI, 

In import set check the case sensitive box, that should check the values for cases and have values as expected.