Map the custom field in the transform map

task australia Updated Jun 29, 2026 1 min read map-custom-field-transform.md

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 and Add a matching column to the pre-import table.

Role required: ot_excel_import_user

Procedure

Navigate to All > Industrial Workspace Admin > OT Manager Admin > Import OT Devices - Data Sources.
Select the SG OT Excel Staging Import record.
Under the Transforms tab, select the sn_otsm_sgc_sg_ot_excel_pre_import transform map record.
Under the Field Maps tab, select New.
Set the Source field value to the same column you created in the SG-OT Excel Pre Import Staging table.
Set the Target value to the same column you created in the SG OT Excel Stagings [sg_ot_excel_staging] table.
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

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.

Parent Topic:Add a custom column to the staging table

Keywords transform mapfield mapfield mapping

53 lines · 3.0 KB Wrap lines

---
title: Map the custom field in the transform map
description: 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.
locale: en-US
canonical_url: https://www.servicenow.com/docs/r/australia/operational-technology/operational-technology-manager/map-custom-field-transform.html
release: australia
product: Operational Technology Manager
classification: operational-technology-manager
topic_type: task
last_updated: "2026-06-29"
reading_time_minutes: 1
keywords: [transform map, field map, field mapping]
breadcrumb: [Add a custom column to the staging table, Configuring the Service Graph Connector for Microsoft Excel, Service Graph Connector for Microsoft Excel, Use, Operational Technology Manager, Operational Technology]
---

# Map the custom field in the transform map

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://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/operational-technology/operational-technology-manager/add-custom-column-staging-table.md) and [Add a matching column to the pre-import table](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/operational-technology/operational-technology-manager/add-column-pre-import-table.md).

Role required: ot\_excel\_import\_user

## Procedure

1.  Navigate to **All** &gt; **Industrial Workspace Admin** &gt; **OT Manager Admin** &gt; **Import 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

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://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/operational-technology/operational-technology-manager/complete-custom-column-import-sgc-excel.md).

**Parent Topic:**[Add a custom column to the staging table](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/operational-technology/operational-technology-manager/add-custom-column-staging-table.md)