---
sourceDocument: Australia Operational Technology Management
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/operational-technology

 Release :

    - australia

ft:locale :

    - en-US

ft:publication_title :

    - Australia Operational Technology Management

ft:clusterId :

    - optm

bundleId :

    - optm

workflow :

    - Technology


---

# Map the custom field in the transform map

# Map the custom field in the transform map {#ariaid-title1}

Release version: Australia  
Updated June 29, 2026  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read  
Map the custom source field on the pre-import table to the target field on the sta table so the imported value transforms into the correct staging column.

## Before you begin

The custom column must be added to both the staging table and the pre-import table before completing this task. For more information, see [Add a custom column to the staging table](https://servicenow-prod.fluidtopics.net/reUjAkpZqJsWsw9APjjSUA "Add a custom column to the SG OT Excel Stagings table to store an additional value imported from the Microsoft Excel spreadsheet.") and [Add a matching column to the pre-import table](https://servicenow-prod.fluidtopics.net/kFT~PdA2aJB7s6S5VBSaQA "Add a column to the SG-OT Excel Pre Import table that matches the custom column on the staging table, giving the imported value a source field for mapping.").

Role required: ot_excel_import_user

## Procedure

1. Navigate to AllIndustrial Workspace AdminOT Manager AdminImport OT Devices - Data Sources.
2. Select the SG OT Excel Staging Import record.
3. Under the Transforms tab, select the sn_otsm_sgc_sg_ot_excel_pre_import transform map record.
4. Under the Field Maps tab, select New.
5. Set the Source field value to the same column you created in the SG-OT Excel Pre Import Staging table.
6. Set the Target value to the same column you created in the SG OT Excel Stagings \[sg_ot_excel_staging\] table.
7. Select Submit.

## Result

The field map is added to the SG-OT Excel Pre Import \[sn_otsm_sgc_sg_ot_excel_pre_import\] table transform map record.

## What to do next

Upload an updated Microsoft Excel spreadsheet to populate the custom column. For more information, see the following tasks:

* [Create an import task](https://servicenow-prod.fluidtopics.net/Z14q5_~~xYw_mN5CcAhR6g "Create an import task for the Service Graph Connector for Microsoft Excel to handle the import of Operational Technology (OT) device data from your Microsoft Excel spreadsheet.")
* [Validate imported staging records](https://servicenow-prod.fluidtopics.net/oiLHGBN0vdDGT9FkAQ6zBA "Validate the imported staging records from your import task to find missing, duplicate, and invalid data.")
* [Trigger a CMDB import for valid staging records](https://servicenow-prod.fluidtopics.net/U1Gv9UW1v5_TZMrMfmXWLw "Trigger a Configuration Management Database (CMDB) import for your valid staging records to directly import them into the CMDB")
{#map-custom-field-transform__ul_c4w_sdf_tjc}

*[\>]: and then