Viewing the decision table as a spreadsheet

You can display a decision table in a spreadsheet view if the decision table has two condition columns and one action column and the structure of the decision table is symmetric.

About this task

You can display a decision table in a spreadsheet view, if the decision table meets the following conditions:

  • The decision table has two condition columns and one action column.

  • The structure of the decision table is symmetric. A decision table is symmetric if, for each row in the first condition column, the same rows are defined for the second condition column.

    Symmetric structure of a decision table

The spreadsheet view of a decision table presents the first condition column as the row header, and the second condition column as the column header. The action column values are represented as cells in the spreadsheet.

Note: This feature is not available in the Decision Center decision tables.

Procedure

To view a decision table as a spreadsheet:

  1. In the decision table editor toolbar, click Switch to Decision Table View button Switch to Spreadsheet View.

    The decision table is displayed as a spreadsheet.

    Decision table displayed as a spreadsheet
  2. To switch back to the decision table view, in the spreadsheet view toolbar, click Switch to Decision Table View button Switch to Decision Table View.