---
sourceDocument: Australia Operational Technology Management
sourceDocumentLink: https://www.servicenow.com/docs/r/australia/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 staging 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://www.servicenow.com/docs/reUjAkpZqJsWsw9APjjSUA "Add a custom column to the SG OT Excel Stagings (sg_ot_excel_staging) table to store an additional value imported from the Microsoft Excel spreadsheet.") and [Add a matching column to the pre-import table](https://www.servicenow.com/docs/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.
{#map-custom-field-transform__steps_p5x_p3p_skc}

## 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

Complete the custom column import by uploading a Microsoft Excel spreadsheet with the custom column data. For more information, see [Complete the custom column import](https://www.servicenow.com/docs/VDwwp67GwW0fkzg5mjKIYg "Upload an updated Microsoft Excel spreadsheet to populate the custom column and complete the import.").

*[\>]: and then