---
sourceDocument: Yokohama Build or modify applications
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/yokohama/application-development

 Release :

    - yokohama

ft:locale :

    - en-US

ft:publication_title :

    - Yokohama Build or modify applications

ft:clusterId :

    - cadev

bundleId :

    - cadev

workflow :

    - Development, Data, and Analytics


---

# Create a table transform map from an extraction table

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

* Release version: Yokohama
* 
* Updated January 30, 2025
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 2 minutes to read

In ERP Canvas, create a table transform map from an extraction table and map the source fields with target fields.

## Before you begin

Role required: 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 ERP Canvas](https://servicenow-prod.fluidtopics.net/5Uc92op0q~_JeNgft8dlAg "Create an ERP (Enterprise Resource Planning) extraction table to capture large amounts of data from the system of record 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 an ERP model](https://servicenow-prod.fluidtopics.net/OX_LJNB6x0Te4D7FgWIe_g "Specify output parameters for an ERP (Enterprise Resource Planning) system read or update operation in ERP Canvas to define how fields and parameters are mapped from the ERP system to the ServiceNow AI Platform. Output parameters also define how returned data is stored on the ServiceNow AI Platform.").  
Note:  
The following procedure always generates a new transform map and 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 AllERP CanvasERP Canvas Home.
2. Open the ERP extraction tables page by selecting the ERP extraction tables icon (![ERP extraction tables navigation 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/access?context=c_ImportSetsKeyConcepts&version=yokohama&pubname=yokohama-integrate-applications&ft:locale=en-US) and [Create a transform map](https://www.servicenow.com/docs/access?context=t_CreateATransformMap&version=yokohama&pubname=yokohama-integrate-applications&ft:locale=en-US).

   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/access?context=c_ImportSetCoalesce&version=yokohama&pubname=yokohama-integrate-applications&ft:locale=en-US).
8. Select Save.  
   The import set staging table and a transform map that can be used by ERP Canvas 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