What is COALESCE explain with example

[Apsara P]

Please Help me

[rishabh33]

Hi @Dan O Connor ,

what if we don't want to add fourth row(empid :004) which is not present in sn ?

[Dan O Connor]

Rows are records. This is data once loaded will appear as a record in a ServiceNow table.

If for example you had a data load with 10 records but only wanted to use lets say 7, you would just remove the three rows you don't want from the data file, so it doesn't import in the first place. 

[KenO36]

I'm studying for my CSA and this was a simple explanation of coalesce and its use case. Thanks!

[Dan O Connor]

You are welcome.

The example above I gave is typical in nearly every customer instance, as likely there will be some form of User LDAP populating User Accounts.

But it also remains true for any data import you might execute.