Microsoft Excel File Format for Decision Tables
The Microsoft excel file needs to fomatted correctly before importing into the Decision Manager as a decision table.
The following figure shows the sample Microsoft excel file that can be imported as a decision table.
The Excel file format has the following characteristics:
Heading | Notes |
---|---|
Version | Version of this table, as stored in the RMS project. |
Declarations Section | |
Path | The project path to the entities used as arguments in the VRF |
Alias | The entity aliases |
Property | Not used in this release. |
Decision Table Section | |
ID | The row (rule) ID |
Condition Action Custom Condition Custom Action | One column for each condition and action, as needed. Each regular Condition and Action column heading is followed by the name of the property whose values are used in the cells of the column. |
Description | Each rule can have an optional description, seen in the Properties view. |
Priority | Rule priority from 1 to 10, seen in the Properties view. Default is 5. |
Exception Table Section | |
Same as Decision Table section. Values appear only if an exception table is defined. See Exception Tables . |
Copyright © Cloud Software Group, Inc. All Rights Reserved.