CSA · Question #361
Which configuration allows you to use a script to coalesce data in Import Sets?
The correct answer is C. Conditional coalesce. Conditional coalesce allows the use of a script to define the conditions under which incoming import set data should match existing records in the target table.
Question
Which configuration allows you to use a script to coalesce data in Import Sets?
Options
- AMultiple-field coalesce
- BNo coalesce
- CConditional coalesce
- DSingle-field coalesce
How the community answered
(32 responses)- B3% (1)
- C94% (30)
- D3% (1)
Why each option
Conditional coalesce allows the use of a script to define the conditions under which incoming import set data should match existing records in the target table.
Multiple-field coalesce matches records based on the values in two or more selected fields, without requiring a script for complex conditions.
'No coalesce' means that every incoming record will create a new record in the target table, never updating existing ones.
Conditional coalesce in Transform Maps enables the use of a JavaScript script to determine whether an incoming import set record should coalesce with an existing record based on custom logic, offering flexible matching criteria beyond simple field comparisons.
Single-field coalesce matches records based on the value of a single selected field, without using a script.
Concept tested: ServiceNow Import Set coalesce strategies
Source: https://docs.servicenow.com/bundle/utah-integrate-applications/page/administer/import-sets/concept/c_CoalesceFields.html
Topics
Community Discussion
No community discussion yet for this question.