Create data mapping

  • Freigeben Version: Australia
  • Aktualisiert 12. März 2026
  • 1 Minute Lesedauer

    • Create data mappings to import Watershed data from columns other than the pre-configured columns of the Watershed spreadsheet. By default, data import from three columns is supported.

    Vorbereitungen

    Role required: sn_esg.program_manager

    Warum und wann dieser Vorgang ausgeführt wird

    By default, you can import data related to carbon emissions, renewable energy, and non-renewable energy. If you want to import other types of data such as water usage or waste disposal from the spreadsheet, then you can create data mappings for them. You can create as many mappings as you need.

    Prozedur

    1. Navigate to All > Metrics > Metrics Integrations.
    2. Select Watershed Integration.
    3. In the Data mapping section, select New.
    4. On the form, fill in the fields.
      Tabelle : 1. Data mapping form
      Field Description
      Name Name of the mapping.
      Source table Source table of the mapping. This field is automatically set to Watershed Data.
      Data column Column from which you want to import data.
      Start date column Column in the source table that has the start date.
      Start date Start date of the mapping. If there is no start date column, specify the start date.
      Frequency Frequency of the data in the spreadsheet. For example, monthly data, annual data, or so on.
      End date column Column in the source table that has end date.
      End date End date of the mapping. If there is no end date column, specify the end date.
      Unit column Unit column from the imported data set.
      Unit Unit of the data.
      Default owner Metric definition owner or the entity owner.
      Metric integration Metric integration. This field is automatically set to Watershed Integration.
    5. Select Submit.

    Ergebnisse

    The new mapping is ready to import data.