We're reclaiming inactive PDIs to keep them available for active builders. Learn what's changing, who's affected, and how to protect your work. Read More

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

abhyodaya_padiy
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

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

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