If a value from an import does not exist in ServiceNow and the import should not create a new record, which option should be selected?

In ServiceNow, when using an Import Set and a Transform Map to process incoming data, the behavior for handling non-matching records is controlled by the Transform Map settings. The question specifies that if a value from the import source does not exist in the target table, a new record should not be created. This is achieved by ensuring the "Create" checkbox on the Transform Map is unchecked. When "Create" is unchecked and no matching record is found (based on the coalesce settings), the system's default action is to ignore the source row and proceed to the next one. No new record is created, and no existing record is updated.

A. Reject: This is a more explicit action, typically set via script (action = 'reject'), which stops the transformation for that specific row and logs it in the import log as an error.

B. Create: This option is the direct opposite of the requirement. Selecting 'Create' would instruct the system to generate a new record when no matching record is found.

C. Delete: This action is not a standard option for handling non-matching source records during an import process. It is not relevant to the scenario of creating or updating records.

1. ServiceNow Product Documentation - Create a transform map:

In the section describing the fields on the Table Transform Map form

the "Create" field is defined: "Select this check box to create a record when a matching record is not found." This directly implies that to not create a record

this box must be unchecked

and the resulting action is to skip (or ignore) the row.

2. ServiceNow Product Documentation - Transform map scripts:

The documentation on onBefore transform scripts explains the special action variable. It states: "action = 'ignore'; //Do not process this row". This confirms that 'ignore' is the official term for the action of skipping a row during transformation

which is the default behavior for non-matching rows when the "Create" option is disabled.