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 illustration 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
Recall that the operator needs to contain two essential space characters:
[operator][space]..[space][operator]
- The first row contains header information - one item for simple columns and three items for range columns. The above example contains two simple columns - input-1 and output-1 and one range column. Range columns are defined by three pieces of information - lower bound, operator and upper bound - and require three identically-named CSV columns to store.
- Subsequent rows contain the data with as many items as there are header items. One item for each simple columns, and three items for each range column.
In the above example, the simple columninput-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.
