Mapping values to an enumeration type

You map the enumeration type to values extracted from an Excel file.

Procedure

  1. In your data model, open the Modeling tab.
  2. Create an enumeration type, or open an existing one.
  3. Click Select file under External data source.
    Note: If you are mapping an existing enumeration type, click Expand button Expand to access the Select file menu.
  4. In the Excel file field, select the Excel file that you uploaded.
  5. In the Sheet field, select the sheet that contains the values that you want to map to your type.
  6. Select the Table with header check box if you have created a header in your Excel file.
    Selecting this check box displays the name of the columns in the drop-down lists instead of the default column letters.
  7. In the Value, Verbalization, and Documentation fields, select the corresponding columns in your Excel file.
  8. Click Save.

Results

The values are displayed as read-only in the data model editor. The values that the enumeration type contained before you mapped it are now tagged as deprecated and can be deleted.