What is the purpose of Empty Coalesce Field in Transform map?

[Community Alums]

Can someone please help me in understanding the use of this field. Where and why will this field will be used?

[akasharora]

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)

Thanks,
Akash

Mark answer helpful or correct if it helps your case.

 

[Shashi Bhushan]

Hi

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

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.

Please mark correct if you find it helpful.

Thanks

[Ben139]

Where is this Coalesce empty fields? I can't find it.

[ArunavaS]

you check coalesce empty, then for target empty field it will update the record in source table instead of creating a new record. Though it is not used very frequently.