---
sourceDocument: Australia Workflow Data Fabric
sourceDocumentLink: https://www.servicenow.com/docs/r/integrate-applications

 Release :

    - australia

ft:locale :

    - en-US

ft:publication_title :

    - Australia Workflow Data Fabric

ft:clusterId :

    - crint

bundleId :

    - crint

workflow :

    - Creator


---

# Create table transform map

# Create a table transform map from an extraction table {#ariaid-title1}

* Release version: Australia
* 
* Updated March 12, 2026
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 2 minutes to read

In Zero Copy Connector for ERP (Enterprise Resource Planning), create a table transform map from an extraction table and map the source fields with target fields.

## Before you begin

Role required: sn_erp_integration.erp_admin

Confirm that you have an extraction table associated with a model containing output parameters. For more information, see [Add a new ERP extraction table in Zero Copy Connector for ERP](https://www.servicenow.com/docs/5PqzKYuEVOgGssIPvsAmPA "Create an ERP (Enterprise Resource Planning) extraction table to capture large amounts of data every day, and save the data to a transformation (staging) table. The data is then available on the ServiceNow AI Platform, and you can add the extracted data to an ERP model or remote table.") and [Choose output parameters for a model](https://www.servicenow.com/docs/q9nzhgMSleqKmiqeQ7zH2w "Specify output parameters for a model operation in Zero Copy Connector for ERP to define which ERP fields map to the ServiceNow AI Platform and how the returned data is stored.").  
Note:  
The following procedure generates a new transform map and a new staging table. To modify an existing transform map or an existing staging table, navigate to the record and update manually. Transform maps are in System Import SetsAdministrationTransform Maps and staging tables are in System DefinitionTables.

## Procedure

1. Navigate to AllZero Copy Connector for ERPZero Copy Connector for ERP Home.
2. Open the ERP extraction tables page by selecting the extraction tables icon ![]() in the side panel.
3. Select an extraction table to work with by selecting the Name.  
   The table should have an ERP model that contains some output parameters.
4. Select Generate mapping.
5. In Select mapping table, specify the destination table for the data obtained from an external source.  
6. Create the mappings by selecting an output in the Available model outputs column and then selecting a column in Available columns.  
   As you work, the mappings are saved in the Field Mapping section to create the import map staging table and the transform map. For general information, see [Import sets key concepts](https://www.servicenow.com/docs/I1J3ifzWRL7k5C8oZuGVMw "Learn about import sets before importing data to your instance.") and [Create a transform map](https://www.servicenow.com/docs/gh_TgUejLqzUBNeH78dWWg "Every import operation to a production table requires at least one transform map associated with an import set.").

   To change a mapping, you can drag the items within the Selected model outputs column or the Selected columns column. As you make changes, the Field Mapping section updates automatically.
7. In the Field Mapping section, select the Coalesce option for each mapping.  
   For more information, see [Updating records using coalesce](https://www.servicenow.com/docs/suMPm9CH3CfxQv~HfLwDQQ "The coalesce option allows you to update existing target table records when transforming import data.").
8. Select Save.  
   The import set staging table and a transform map that can be used by Zero Copy Connector for ERP to push the data into the destination table are generated. The extraction table record opens. A confirmation message is displayed stating that the staging table was generated and there's a link to the transform map.
9. Select the link at the top to open the transform map.  

   In Source table, the staging table is listed with its auto-generated name. The Field Maps related list contains the fields you mapped.
10. Return to the extraction table record (it might be open in a different browser tab).
11. To view the transform map at any time, select the link in Table transform map link.

*[\>]: and then