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