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. On the Workflow tab, under Data Load, select Data Load Mapping.

  2. Select the All Mapping tab.

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

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

  5. In Select mode and validation, in 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 it 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 shows the description of “System Generated Mappings.”