Extracting values from an external data source
You can populate enumeration types with values extracted from an Excel file.
You can import sets of values stored and managed in an Excel file outside of Decision Designer. The Excel file is stored as an external data source in the data model. You can modify the Excel file and then upload the changes to Decision Designer.
The Excel file must have the following structure:
- Value column
- You must create a value column to enter the values you need.
- Verbalization column
- You must create a verbalization column to define the verbalization of each value. The verbalization is the name displayed for the value when editing a rule.
- Documentation column
- The documentation column is optional. You can create a column to enter documentation on a value.
- Sheets
- You can have several sheets in the same Excel file. Each worksheet corresponds to a set of values.
An Excel file template is available in the External data sources tab in your data model.