CAD practice question 25 of 35

What is the purpose of the coalesce field when importing data?

Full set: 264 questions
Answer options
A: When a match is found, a new record is inserted
B: To determine if a record matches an existing record or is a new record Correct answer
C: If a match is not found, the existing record is updated
D: To identify and merge duplicate records
Correct Answer:
B. To determine if a record matches an existing record or is a new record
Explanation

In an import set field map, marking one or more fields as “Coalesce” tells ServiceNow to treat the combination of those field values as a unique key. During transform, the platform compares incoming rows against existing records on that key: if a match exists, the record is updated; if no match exists, a new record is inserted. Thus, the coalesce setting’s sole purpose is to determine whether each incoming row already has a corresponding record or represents a new one.

Why Incorrect

A. Inserts occur only when no coalesce match is found; a match triggers an update, not an insert.
C. Reverses the logic—the existing record is updated when a match is found, not when one is absent.
D. Coalesce does not merge duplicates across the table; it simply decides update vs. insert during the transform run.

References

1. ServiceNow Product Documentation → “Import Set Field Map - Coalesce” (Tokyo release), docs.servicenow.com → Now Platform > System Import Sets > Define Field Maps, paragraph 3: “The platform uses coalesce fields to determine if a record exists. If a match is found, the existing record is updated; otherwise, a new record is inserted.”

2. ServiceNow System Administration Courseware, Module “Data Management,” section “Using Coalesce,” p. 18 (Madrid+), explains coalesce as the unique key to decide update vs. insert.

3. ServiceNow Developer Site, Article “Importing Data with Transform Maps,” step 5: “Select Coalesce to have the transform map search for existing records… update on match, insert on no match.”

Scroll to Top