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

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.