Update all records when transform map matched the multiple records, coalesce is on one field only

[D_R]

Update all records when transform map matched the multiple records, coalesce is on one field only.

Can we update all matching records?

[shubhamdubey]

@D_R 

Coalesce maintain the uniqueness of the records.

https://developer.servicenow.com/dev.do#!/learn/learning-plans/utah/new_to_servicenow/app_store_lear...

[Anamika Gupta]

If there is coalesce on one field and transform map matched the multiple records it means you have duplicate records in refernece of to coalesce field.

If more than one record in the target table matches the specified coalesce options, only the first matching record in the target table is updated. you cannot update all records.

If you want to update all records remove coalesce

[D_R]

does it update the first matching record or since there are multiple matching records so skip all the records?

[Anamika Gupta]

Yes, It will update first matching record only and ignore all other records