Initializing help system before first use

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.
Editing Decision Tables as CSV files

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.

Parent Topic Working with the Decision Table Editor