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:

[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 either side of one range column. The range is generated by 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.

© 2001-2024 Fair Isaac Corporation. All rights reserved. This documentation is the property of Fair Isaac Corporation (“FICO”). Receipt or possession of this documentation does not convey rights to disclose, reproduce, make derivative works, use, or allow others to use it except solely for internal evaluation purposes to determine whether to purchase a license to the software described in this documentation, or as otherwise set forth in a written software license agreement between you and FICO (or a FICO affiliate). Use of this documentation and the software described in it must conform strictly to the foregoing permitted uses, and no other use is permitted.