Thank you for your feedback.
Form temporarily unavailable. Please try again or contact docfeedback@servicenow.com to submit your comments.
Versions
  • Madrid
  • London
  • Kingston
  • Jakarta
  • Istanbul
  • Helsinki
  • Geneva
  • Store
Close

Create a transform map

Log in to subscribe to topics and get notified when content changes.

Create a transform map

Every import operation to a production table requires at least one transform map associated with an import set.

Before you begin

Role required: import_transformer, import_admin, or admin

About this task

The transform map specifies the data relationships between the import set and the target table. For every transformation, you must either create a new transform map or select an existing one.

Procedure

  1. Navigate to System Import Sets > Create Transform Map.
  2. Complete the form.
    Table 1. Table transform map fields
    Field Description
    Name User-friendly label to identify the transform map.
    Source table Import table containing the raw import set data. An import table is any table that extends the Import Set Row [sys_import_set_row] table. You can select only tables within the currently selected application scope.
    Active Check box to make the transform map available for use.
    Run business rules Check box to run business rules, workflows, approval engines, auditing, and field normalization while the transformation inserts or updates data into the target table. Clearing this check box runs GlideRecord.setWorkflow() with a value of false.
    Enforce mandatory fields Selects whether to enforce mandatory fields on the target table:
    • No: Do not enforce mandatory fields.
    • Only Mapped Fields: Enforce mandatory mapped fields only.
    • All Fields: Enforce all mandatory fields.
    Copy empty fields Check box to copy empty field values and override existing target field values.
    Create new record on empty coalesce fields Check box to create a new record when all coalesce fields are empty, instead of ignoring the record or overwriting an existing record.

    If Coalesce empty fields is selected for any field in the record, the record is coalesced.

    Application Application scope: global or per application.
    Created Transform map creation date (populated automatically).
    Target table The table in which you want the transformed data to be inserted. You can select only tables within the currently selected application scope or the global scope, or tables that grant write access to other applications.
    Order Order in which to apply transform maps if more than one map fits the conditions. The system runs transform maps from lowest to highest Order.
    Run script Check box to define a script that transforms field values in the source table to the target table.
    Script Transform map script that transforms field values in the source table to the target table. The system runs the transform map script in addition to any field maps.
    Important: The string NULL is a reserved word. It should not be used as a field value in import set transform maps or anywhere in the First name or Last name fields. The reserved word is NULL in all capital letters. A field with the value Null or null, for example, is acceptable. NULL should be used only to clear out a particular field.
Feedback