Xpress Insight supports the execution of decision tables of up to 50,000 rows if they are created as CSV files in an external editor, such as Excel or a text editor.
The following example shows a CSV representation of the previous figure, which depicts a decision table in
Xpress Insight's visual editor.
A Decision Table as a CSV File
When editing a data row, remember that the operator must be contain two essential by space characters:
[operator][space]..[space][operator]
- The first row contains header information—simple columns are described by one item, range columns require three items. The example contains two simple columns—input-1 and output-1 which bracket one range column which requires three identically-named CSV columns (input-2).
- Subsequent rows contain the data with as many items as there are header items. One item for each simple column, and three items for each range column—lower bound, operator and upper bound
In the example, the simple column input-1 has a value of * (a wildcard value) and the simple column output-1 has a value of 5. The range column input-2 has a lower bound of 1, an upper bound of 2 and uses the operator < .. <=, defining a range that is above 1 and less than or equal to 2.
