What is coalesce checkbox and How it execute

[kpathak1803]

What is coalesce checkbox and How it execute? 

Please do let me know.
Thank you!

[G Ponsekar · Accepted solution]

Hi @kpathak1803 ,

Coalesce is a feature in ServiceNow that determines if a row in a staging table matches a record in a target table. It can be used to prevent duplicate data and update existing records instead of creating new ones.

Coalesce is like unique key, if match found then update else create a new record

If I could help you with your Query then, please hit the Thumb Icon and mark as Correct !!

Thanks, GP

[G Ponsekar · Accepted solution]

Hi @kpathak1803 ,

Coalesce is a feature in ServiceNow that determines if a row in a staging table matches a record in a target table. It can be used to prevent duplicate data and update existing records instead of creating new ones.

Coalesce is like unique key, if match found then update else create a new record

If I could help you with your Query then, please hit the Thumb Icon and mark as Correct !!

Thanks, GP

[kpathak1803]

Thank You ! 

[Juhi Poddar · Accepted solution]

Hello @kpathak1803 

• In Transform Maps (used during data imports in ServiceNow), the Coalesce checkbox determines how records are matched between the Import Set table and the target table.
• It tells ServiceNow to use that field to find an existing record in the target table. If a match is found, the existing record is updated. If not, a new record is created.
• You can coalesce on more than one field (e.g., First Name + Last Name) to make sure you're updating the right record.

The following post and article can be helpful: 

• What is COALESCE explain with example
• Coalescing

Hope this helps!

"If you found my answer helpful, please like and mark it as an "accepted solution". It helps future readers to locate the solution easily and supports the community!"

Thank You
Juhi Poddar

[kpathak1803]

Thank You