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

[Surya31]

Thank you Saurav for the clarification and detailed explanation

[Saurav11 · Accepted solution]

Hello Surya

You can only mark one answer as correct

So request you to mark my answer as correct as i was able to answer both your queries

Thanks 

[Saurav11]

You did Thanks

[palanikumar]

Hi,

Purpose of coalesce to to update the record if match found.

Suppose you are trying to import data into table a and coalesce is set on field id. Following is the outcome

Source table data before import

1
2
<empty>

Excel data

2
3
<empty>

If coalesce is not set then you'll get the following data in table after import

1
2
<empty>
2
3
<empty>

If coalesce is set on id field with out enabling Coalesce empty field then you'll have following data

1
2
3
<empty>
<empty>

If coalesce is set on id field with enabling Coalesce empty field then you'll have following data

1
2
3
<empty>

Hope this answers your question

[Surya31]

Thank you Palani Kumar for clear explanation