Coalesce Field Not Working

[nateweldon]

Community, has anyone had an issue where even though a field is set to coalesce on transform duplicate values of that record are still being created? I'm currently migrating some asset management data and the asset tag is the field I'm coalescing on. I've created a smaller version of the file I'm trying to import that has 9 duplicate asset records and it's creating all 9 yet the asset tag is the same value, I've also validated that there is no random text being added to the import set row entries. I've recreated the transform map, the field transform, still the issue persists. Has anyone encountered this before? Is there a table attribute or property I need to check for? 

[Mike Patel]

try changing choice action to ignore. Also make sure there is no other transform map on that source table. Also share screenshot.

Example:

[Gaurav Shirsat]

Hi 

There might be the breaking of transform map script

Please Go Through this Article.

https://community.servicenow.com/community?id=community_question&sys_id=7986ab6bdb443b8023f4a345ca96...

https://community.servicenow.com/community?id=community_article&sys_id=025f57b6db8d7f04200f0b55ca961...

Please Mark Correct and Helpful

Thanks and Regards

Gaurav Shirsat

[Ankur Bawiskar]

Hi,

can you share the field maps and transform map you have configured?

Regards
Ankur

[nateweldon]

Here is the screen shot of my transform.