Importing Excel Mappings

You can import Excel mappings by selecting the Import option and selecting an Excel mapping.

Note:

The import of mapping rules using an Excel template does provides a place to specify a mapping script.

  To import an Excel mapping:

  1. From the Workflow tab, select Data Load Mapping.

  2. Select the All Mapping tab.

  3. From the Import drop-down, select Import from Excel.

  4. From Select a file to import, select the Excel file to import and click OK.

  5. From Select mode and validation, and then Import mode, select the import mode

    Image shows Select import mode and validation screen

    • Merge—Overwrites the data in the application with the data in the Excel data load file.

    • Replace—Clears values from dimensions in the Excel data load file and replaces them with values in the existing file.

  6. Click Validate to validate the mappings.

  7. Click OK.

    The mapping inherits the default data load rule, and the description of “System Generated Mappings.”