Welcome to Community Week 2025! Join us to learn, connect, and be recognized as we celebrate the spirit of Community and the power of AI. Get the details  

Coalesce on multiple fields, is all fields validated before making a change?

abhyodaya_padiy
ServiceNow Employee
ServiceNow Employee

In a transform fields, I have coalesce on 2 fields . So while transforming, is my imported record for validated against all fields   marked as coalesce?

1 ACCEPTED SOLUTION

shimongabai
ServiceNow Employee
ServiceNow Employee

When you coalesce on two fields both fields need to be validated before a change is made.


If multiple fields are set to coalesce, all coalesce values must match an existing record. If two fields are set for coalescing and a matching value is found for one of the coalescing fields but not on the other, a new record is inserted.


For more information please review:


http://wiki.servicenow.com/index.php?title=Creating_New_Transform_Maps#gsc.tab=0


View solution in original post

1 REPLY 1

shimongabai
ServiceNow Employee
ServiceNow Employee

When you coalesce on two fields both fields need to be validated before a change is made.


If multiple fields are set to coalesce, all coalesce values must match an existing record. If two fields are set for coalescing and a matching value is found for one of the coalescing fields but not on the other, a new record is inserted.


For more information please review:


http://wiki.servicenow.com/index.php?title=Creating_New_Transform_Maps#gsc.tab=0