Create a transform map

Create a transform map to match the columns from the staging table to the columns in the target table. The transformation helps to convert the data from the source table into metric data.

Before you begin

If you already have manual Metric Definition in the system before the import, you must change the type of metric definition to Automated and the method type to External source.

​Role required: sn_esg.program_manager

About this task

A map is transformed when you import data from a staging table such as Watershed Data [sn_esg_watershed_data] to a target table such as Metric Data [sn_grc_metric_metric_data]. By default, there are three transform maps available for each table when you import data from Watershed.

Procedure

1. Navigate to Environmental, Social, and Governance > Watershed > Import Sets.
2. Open the import set that you created.
3. Under Related Links, select Transform.
4. On the Specify Import Set and Transform map form, move the required maps from the Available column to the Selected maps run in order column.
5. Select Transform.