what is difference between "Create new record on empty coalesce fields" and "Coalesce empty fields"

[Rohith16]

what is difference between "Create new record on empty coalesce fields" and "Coalesce empty fields"

[Ankur Bawiskar]

Hi Rohith,

what it will try to search is; if incoming value is empty and it finds a record with empty field value for that field map it will update

Mark Correct if this solves your issue and also mark Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[AbhishekGardade · Accepted solution]

Hello Rohith,

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.

If there is a field for example "name" and this value is empty in target record, it will use coalesce when source data has empty value. (when empty coalesce is true)

The field map Coalesce empty fields field allows you to coalesce on fields with no value.

Please mark as Correct Answer/Helpful, if applicable.
Thanks!
Abhishek Gardade

[Ruhi Jibhyenka1]

Hi Rohith,

Coalesce empty fields- Coalesce means to restrict duplicate records and we apply coalesce on fields. So it means you are applying coalesce on empty field. 

Check out below links-

https://docs.servicenow.com/bundle/geneva-servicenow-platform/page/administer/import_sets/concept/c_...

https://community.servicenow.com/community?id=community_question&sys_id=d80d374ddbf65f000be6a345ca96...

Mark Correct if this solves your issue and also mark Helpful if you find my response worthy.

Thanks,

Ruhi.