How many fields can you coalesce on within a transform map

[mballinger]

Hello,

What is the maximum number of fields that can be coelesced on within a transform map?

I have a transform map configured with 12 field mappings. 7 are being coaelesced on and records are still inserting. When I brought it down to 6, only a few duplicate records were inserting. When I coelesced on 1 field, no duplicates were found.

You may be wondering why so many fields are needed to coalesce. Well that is the business side of the house and this is how they uniquely identify records. I've tried to bring the number down but they are not able to do so. I can create a transform script for further processing, but am trying to go the no code route.

I haven't been able to find the answer online, but would greatly appreciate it if someone can assist me with this.

Thanks!

[Harish KM]

Hi you can have multiple coalesces. How does it works you can refer official snow doc below

https://docs.servicenow.com/en-US/bundle/sandiego-platform-administration/page/administer/import-sets/concept/c_ImportSetCoalesce.html

https://www.servicenowelite.com/blog/2014/3/30/coalesce-methods

[Mark Manders · Accepted solution]

The more fields need to be unique when inserting, the higher the chance of creating a new record. It looks for all the fields on a record and if even one is different, it doesn't update, but creates a new one.

If my answer helped you in any way, please then mark it as helpful.

Mark