{"revision":"c10276e953456835cdbb1f3a60d58ae1980be353","document":{"id":22241,"path":"integrate-applications/system-import-sets/t_CreateATransformMap.md","title":"Create a transform map","bundle":null,"doc_type":null,"release":"australia","body":"\n# Create a transform map\n\nEvery import operation to a production table requires at least one transform map associated with an import set.\n\n## Before you begin\n\nRole required: import\\_transformer, import\\_admin, or admin\n\n## About this task\n\nThe 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.\n\n## Procedure\n\n1. Navigate to **All** > **System Import Sets** > **Create Transform Map**.\n\n2. Complete the form.\n\n\n
\n\nField\n\n\n\nDescription\n\n
\n\nName\n\n\n\nUser-friendly label to identify the transform map.\n\n
\n\nSource table\n\n\n\nImport 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.\n\n
\n\nActive\n\n\n\nCheck box to make the transform map available for use.\n\n
\n\nRun business rules\n\n\n\nCheck 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**.\n\n
\n\nEnforce mandatory fields\n\n\n\nSelects whether to enforce mandatory fields on the target table:- **No**: Do not enforce mandatory fields.\n- **Only Mapped Fields**: Enforce mandatory mapped fields only.\n- **All Fields**: Enforce all mandatory fields.\n\n\n
\n\nCopy empty fields\n\n\n\nCheck box to copy empty field values and override existing target field values.\n\n
\n\nCreate new record on empty coalesce fields\n\n\n\nCheck 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.\n\n
\n\nApplication\n\n\n\nApplication scope: global or per application.\n\n
\n\nCreated\n\n\n\nTransform map creation date \\(populated automatically\\).\n\n
\n\nTarget table\n\n\n\nThe 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.\n\n
\n\nOrder\n\n\n\nOrder in which to apply transform maps if more than one map fits the conditions. The system runs transform maps from lowest to highest **Order**.\n\n
\n\nUse Secondary Storage for References\n\n\n\nOption to use a secondary database to look up reference fields.\n\n Importing a high volume of data that includes many reference fields might cause performance issues. Using secondary storage enables some read queries to be redirected to a secondary database, reducing the load on the primary database.\n\n When using secondary storage, set the **Choice action** field in the field map to **ignore** or **reject**. Setting the **Choice action** to **create** may cause multiple copies of a record to be created because the reference resolution doesn't detect newly created records immediately. For more information, see [Create a field map](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/integrate-applications/system-import-sets/t_CreatingAFieldMap.md).\n\n A secondary database is always slightly out of date compared to the primary database. If your import requires completely up-to-date data, don't use secondary storage.\n\n This field appears only when the Secondary Database Pools \\[com.glide.secondary\\_db\\_pools\\] plugin has been activated, and the import\\_reference\\_resoultion secondary database category has been configured and enabled. For more information, see [Large data imports with many reference fields](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/integrate-applications/system-import-sets/c_TroubleshootImportSetPerformance.md).\n\n
\n\nRun script\n\n\n\nCheck box to define a script that transforms field values in the source table to the target table.\n\n
\n\nScript\n\n\n\nTransform 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.\n\n
**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.\n\n\n**Parent Topic:**[Importing data using import sets](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/integrate-applications/system-import-sets/c_ImportDataUsingImportSets.md)\n\n"}}