Editing Decision Tables as CSV files
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.
|
Important Do not leave any empty cells in the CSV when using the Decision Table Editor.
|
The following example shows a CSV representation of the previous figure, which depicts a decision table in
Xpress Insight's visual editor.
When editing a data row, remember that the operator must be contain two essential space characters:
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 either side of one range column. The range is generated by three identically-named CSV columns (
input-2).
[operator][space]..[space][operator]
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.