In transfrom map , if the colease field is empty for multiple records , in source table the records gets updated. We have checked this to true , 'Create new record on empty coalesce fields' on transform map.Can i know how the records with empty colea

[NA13]

In transfrom map , if the colease field is empty for multiple records , in source table the records gets updated. We have checked this to true , 'Create new record on empty coalesce fields' on transform map. Can i know how the records with empty colease fields get inserted?

[Sulabh Garg]

Hello

This is expected behavior, If you checked the "Create new record on empty coalesce fields" then system will check if the coalesce field is empty then it will insert the new record in target table  or if there is already empty coalesce field in target table then it will update that record as it match with the empty coalesce field.

By default, fields marked as Coalesce in the field map cause the import set to check for a target record with a field value that matches the value from the import set staging record. When Coalesce empty fields is selected for that field map, an empty value in the target record and import set staging record counts as a match for the purpose of coalescing.

For example, the User transform map coalesces on the email field. With the Coalesce empty fields option selected, a source record containing an empty email address coalesces to a target record containing an empty email address.

 For more info please visit Updating records using coalesce

Please Mark ✅ Correct/helpful, if applicable, Thanks!! 

Regards

Sulabh Garg

[Sulabh Garg]

Hello, Hope my answer helped you, Please mark my response as correct and helpful, if applicable. Thanks