What is Coalesce in ServiceNow?

[alex_04]

What is Coalesce in ServiceNow?

[Harish Bainsla]

Hi @alex_04 

Coalesce is a feature in ServiceNow that matches records from a source to a target table during data imports: 

• Purpose

  Coalesce helps to avoid duplicate data and improve the performance of data loads 

How it works

Coalesce makes a field a record's unique key. When importing data, ServiceNow matches the source values to the existing target values. If there is a match, the record is updated, and if there is no match, a new record is inserted 

For more detail below link help you

https://www.servicenow.com/community/itsm-forum/what-is-coalesce-explain-with-example/td-p/2341075

if my answer helps you mark helpful and accept solution 

[PrabhakarCh]

@alex_04 

Coalesce is a true/false value between a source Import Set field and a target table field in ServiceNow. It is set in the Transform Map. Coalescing a field means the field will be used as a unique key during imports. If a match is found using the coalesce fields, the existing record will be updated with the information being imported. If a match is not found using the coalesce fields, then a new record will be inserted into the database.

Coalescing | ServiceNow Developers

--------------------------------

If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

-------------------------------------

Best,

PC

[Runjay Patel]

Hi @alex_04 ,

Coalesce refers to a feature used to identify unique records in a table during an import process. When importing data, ServiceNow needs to know which fields should be used to match incoming records with existing records in the system.

For example, if you are importing user data into the sys_user table, you might use the user_id as a coalesce field. This way, if the user_id already exists in the system, the imported record will update the existing record instead of creating a new one.

Accept and mark helpful if my response helped you.

[Anand Kumar P]

Hi @alex_04 ,

The coalesce option allows you to update existing target table records when transforming import data.

The coalesce option on a field map allows you to specify if the selected Target field should be used to coalesce on when import set records are transformed. If the field map Coalesce checkbox is selected, when the import set row is transformed the instance checks for an existing record in the target table that has the same value in the Target field as the import set row Source field.

If an existing record with a matching value in the target table is found, that record is updated. If no matching record is found, then a new record is created in the target table.

If my response helped, please mark it as the accepted solution ✅ and give a thumbs up👍.
Thanks,
Anand