Difference between coalesce , create coalesce true on field and create coalesce on empty fields. Can any one give an example

[Surya31]

I need a basic understanding of coalesce , create coalesce true on field/Column and create coalesce on empty fields. Can any one give an example

[Saurav11]

Hello,

If you mark coalesce = true, and coalesce empty fields = false then records will be skipped, and new records will not be created.

If you mark coalesce = true, and coalesce empty fields = true then  Records will be inserted.

Please mark answer correct/helpful based on Impact.

[Saurav11]

Hello,

If my answer helped you can you also mark it as correct.

Thanks.

[Surya31]

Hi Saurav,

Can you give detailed explanation on , left navigation->transform map, Create new record on empty coalesce fields (checkbox), if i checked what happen and uncheck what happen?

Thanks for the reply

[Saurav11]

Hello Surya,

if the checkbox is false 

For example, the User transform map coalesces on the email field. With the Coalesce empty fields option selected as false, a source record containing an empty email address will just ignore and not update any record even if there are records with email id as empty

if the checkbox is true

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

Hope it helps!!

Please mark answer correct/helpful based on Impact.