LogoLogo
API Documentation
Current Version
Current Version
  • DecisionRules Documentation
  • DecisionRules Academy
  • API
    • API Introduction
    • API Keys
      • Solver API Keys
      • Management API keys
      • BI API keys
    • Rule Solver API
    • Management API
      • Rule Migration Strategies
      • Deprecated Endpoints
    • Console Logs API
    • Business Intelligence API
      • Deprecated Endpoints
    • Datacenters & Locations
      • Global Cloud
      • Regional Cloud
    • Apache Kafka Solver API
    • Endpoint Settings
    • Archive
      • Rule Flow Solver API (DEPRECATED)
  • AI Assistant
    • About Assistant
    • Assistant Setup
      • Gemini Assistant
  • RULES
    • Rules Introduction
    • Rule List
    • Rule Mode
    • Common Rule Features
      • Input & Output Model
        • Simple Editor
        • JSON Editor
      • Test Bench
      • Rule Alias
      • Rule State
      • Versioning
      • Rule Variables
      • Execution Strategy
      • Rule Dependencies
      • Rule Export & Import
        • Rule Export
        • Rule Import
        • Managing Decision Table in Excel/Google Sheets
        • Deprecated Formats: XLSX v.1 and CSV
      • Tags
      • Rule Comparison
        • Decision Table Comparison
        • Decision Tree Comparison
        • Scripting Rule Comparison
      • Rule Lock
      • Teamwork Indicator
      • Event Timeline
    • Data Types & Functions
      • Supported Data Types
      • Operators and Functions
        • Basic operators
        • Date operators
        • Functions
          • Logical Functions
          • Math Functions
          • Date and Time Functions
          • Text Functions
          • Data Functions
          • Array Functions
          • Integration functions
          • Functions and JSON
    • Decision Table
      • Table Designer
        • Table Operations
          • Filter Values
          • Valid Values
          • Sorting
      • Binding to Model
    • Decision Tree
      • Tree Designer
    • Workflow
      • Workflow Designer
      • Workflow Nodes Overview
      • Workflow Limits
    • Scripting Rule
      • Custom functions in Scripting Rules
      • Calling external API within ScriptingRules
      • Use Rule Variables in Scripting Rules
      • Call Embedded Rules in Scripting Rules
      • Tips
    • Rule Flow
      • Rule Flow Designer
      • Rule Flow Mapping
      • Rule States in Rule Flow
      • Warnings & Errors
      • Rule Flow Limits
  • SPACE
    • Space Introduction
    • Space Info
    • Dashboard
    • Access
    • API Keys
    • Audit Logs
  • Organization
    • Organization Introduction
    • Organization List
    • Members
    • Teams
    • Spaces
    • Space Roles
    • Policies
    • Statistics
    • Settings
  • Profile
    • Profile Introduction
    • General
    • Dashboard
    • Plans
    • Add-ons
    • Limits
      • Plan Limits Explained
    • Subscriptions
    • Invoices
  • Access
    • Sign Up & Login
    • Invitations & Permissions
    • Single Sign-On (SSO)
  • Business Intelligence
    • Audit Logs
    • Power BI Connectivity
      • Create a Power BI Report
      • Connect Power BI to Business Intelligence API
      • Connecting from Power BI (deprecated)
      • Connect DecisionRules to Power BI Using Our Custom Connector
  • OTHER DEPLOYMENT OPTIONS
    • Regional Cloud
      • Region Specific API URLs
    • Docker & On-Premise
      • Environment Variables
      • Redis Connection Modes
      • DecisionRules Application
        • Minimal Requirements
        • DecisionRules Server
        • DecisionRules Client
        • DecisionRules Business Intelligence
        • Networking Between Docker Containers
      • Setup Single Sign-On (SSO)
        • Set up Microsoft Entra ID SSO
        • Set up Google SSO
      • Docker Showcase App
        • Showcase
        • Showcase + Business Intelligence
      • AWS Setup
        • AWS ECS/Fargate
        • Cache - Amazon ElastiCache
      • Microsoft Azure Setup
        • Database - Azure CosmosDB
        • Cache - Azure Cache for Redis
        • Azure Container Apps
      • Azure Red Hat OpenShift
      • Google Kubernetes Engine (GKE)
      • Kubernetes Setup
        • Kubernetes Setup with Business Intelligence
      • Logging options
      • CD/CI Pipelines
        • Azure DevOps CICD Pipelines
        • Using Migration script (old way)
      • Offline License
      • White Labeling
  • SDK and Integrations
    • Languages / Frameworks
      • SQL Server
      • Oracle PL/SQL
      • PostgreSQL
      • JavaScript
      • Java Spring Example
      • PHP Library
      • Python Library
      • .NET Library
      • Google Tag Manager
    • Excel Add-in
  • Terms & Conditions
    • Terms and Conditions
    • Privacy Policy
    • Service Level Agreement
      • Community Support
      • Standard Cloud (SaaS)
      • Silver SLA
      • Gold SLA
      • Custom SLA
    • Sub-Processor List
  • Product Updates
    • Release Notes
      • Public Cloud
      • On-Premise / Private Cloud
    • Major Updates
      • Changes in Version 1.19.0 (10/2024)
      • Changes in Version 1.20.0 (4/2025)
    • Roadmap
Powered by GitBook
On this page
  • Applying changes
  • Column Types and Table Structure
  • Column Operations and Settings
  • Add Column
  • Rename Column
  • Select Column Value
  • Set Column Alias
  • Delete Column
  • Row
  • Add Row
  • Fill Cell
  • Copy Row
  • Clear Row
  • Deactivate and Activate Row
  • Delete Row
  • Use Row in Test Bench
  • Change the Order of Rows
  • Time Row Validation
  • Debug
  • Additional Options
  • Default Row
  • Check Table for Duplicates
  • Search
  • Go to Row
  • AutoSave Button
  • Highlight Active Columns and Rows
  • Rule History & Undo/Redo

Was this helpful?

  1. RULES
  2. Decision Table

Table Designer

The heart of the Decision Table

Last updated 7 months ago

Was this helpful?

In this section, you can easily create your decision tables, then link them to input and output data. Business rules are created to easily design or change the rules and deploy them quickly.

Applying changes

All the changes are made to the current table version.

Column Types and Table Structure

A Decision Table consists of three types of columns:

  • Condition: Defines input values. As the name suggests, these are the conditions that determine whether a table row matches the input data.

  • Calculation: Used to perform various calculations. These calculations are not initially bound to an input or output model, but they can be mapped to an input or output value if needed.

  • Result: Specifies the output values.

Every Decision Table requires at least two columns: a condition or calculation column and a result column. Condition columns must be placed on the left side of the table, while result columns are on the right. Calculation columns can be positioned anywhere within the table.

Column Operations and Settings

Add Column

To add a new column, hover over an existing column header and click the plus symbol that appears on either side of the column.

Next, select the column type (e.g., "Add Calculation").

As noted in the previous section, there are specific restrictions on where certain types of columns can be placed:

  • A condition column can be added between existing condition columns or at the start of the table as the first column.

  • A result column can be added between existing result columns or as the last column, after any result or calculation columns.

  • Any type of column can be added between condition and result columns.

  • Calculation columns can be placed anywhere in the table.

Rename Column

New columns are initially named according to their type. You can rename a column for better clarity and organization within the table. To do this, click on the existing name (e.g., "Condition") and type the new name. Then, click anywhere outside the field or press the Enter key to confirm.

Select Column Value

Next, select a value for the column. To do this, click the input field under the column name. This will expand a list of all possible values, allowing you to choose one.

There are different types of values that you can map a column to, depending on the column type:

  • Condition Columns: Can be mapped to an input value from the I/O Model, rule variables, or a calculation column variable (only in columns that are to the right of the specified calculation column).

  • Calculation Columns: Are not mapped to an existing value. Instead, a new calculation variable is created. See the detailed explanation below.

  • Result Columns: Can only be mapped to output values from the I/O Model.

Special Case: Calculation Column

Calculation columns are not bound to any existing value. When creating a calculation column, the result is assigned to a variable, which is defined in the calculation column header.

By default, the column is assigned a variable name like varX (where X is a natural number). You can change this name by clicking on it. To confirm the new name, click anywhere outside the field or press the Enter key.

Once defined, these variables can be used elsewhere in the table in the same way as rule variables or input and output values.

Set Column Alias

Aliases are automatically generated for each column, but you can set your own, more descriptive alias. To set a column alias, click the arrow icon in the column header and select the "Set Column Alias" option. The new alias must be unique within the table and can only contain English letters, numbers, and dashes, with a maximum length of 30 characters. To confirm the new alias, click anywhere outside the field or press the Enter key.

Delete Column

To delete a column from the Designer, click an arrow icon near the column name in the header of the condition, then click the remove button in the dropdown menu.

Row

Add Row

Fill Cell

The basic structure for every cell is operator + value.

Operators

To change the operator in a Condition column, click the operator label, and an operator selection modal will open. Select the desired operator to apply it to the cell.

Note: For function operators, selecting a new function operator will not overwrite the existing one in the cell, as function operators can be nested. This ensures that your existing functions are preserved.

For Calculation columns, the operator is predefined as a function; therefore, the operator label is not visible in the cell.

For Result columns, there are two types of operators:

  • Simple Value (Equal): Used for strings and simple math operations like addition (+), subtraction (-), multiplication (*), etc.

To switch between Simple Value and Function operators, click the operator badge and choose from the dropdown:

Warning: Operator Precedence and Brackets

When using function operators in Result and Calculation columns, be mindful of operator precedence. In some cases, the solver evaluates subtraction and other operations from right to left. For example, if you write an expression like 10 - 5 - 2, the solver will first calculate 5 - 2, resulting in 3, and then subtract that from 10, returning 7 instead of the expected 3.

To avoid unexpected results, always use brackets to clarify the order of operations. For example, to get the correct result of 3, you should write the expression as (10 - 5) - 2.

This behavior applies to both Result and Calculation columns when using function operators.

Values

To change the cell value, click on the cell and start typing. To confirm the value, click elsewhere or press the Esc key. You can also enter multiline values by pressing Enter. When the cell is closed, only the first line is visible.

To confirm the new value and exit maximized mode, click the cross icon in the top-right corner, press Esc, or click elsewhere.

Special Case — Variable Values

In addition to classic values, you can also use variables such as input & output values, rule variables, and calculation column variables. To do this, start typing { in the cell, and a dropdown with all available variables will appear.

  • Output values are available only in result columns.

  • Calculation variables are available only after they are declared — i.e., in columns to its right.

Once added, each variable is displayed with its own badge based on its type for better orientation within the table:

If a variable is deleted, it will appear with a red badge in the cells, indicating that the reference is now broken.

Copy Row

To copy multiple rows at once, hold the Ctrl key and click on the rows you want to copy. Then, right-click anywhere in the rows settings area. When the context menu opens, select the "Copy to" option and choose where you want the rows to be copied: either the start or end of the table.

Clear Row

To clear multiple rows at once, hold the Ctrl key and click on the rows you want to delete. Then, right-click anywhere in the rows settings area. When the context menu opens, select the "Clear rows" option.

Deactivate and Activate Row

By default, all rows in the table are ACTIVE. You can use this functionality when you don’t want to use a specific row in the rule for validation, but might need it in the future.

If a row is set to INACTIVE, it behaves as if it does not exist.

To activate or deactivate multiple rows at once, hold the Ctrl key and click on the rows you want to delete. Then, right-click anywhere in the rows settings area. When the context menu opens, select the "Activate rows" or "Deactivate rows" option.

Delete Row

To delete multiple rows at once, hold the Ctrl key and click on the rows you want to delete. Then, right-click anywhere in the rows settings area. When the context menu opens, select the "Delete Rows" option.

Use Row in Test Bench

Change the Order of Rows

To move multiple rows at once, hold the Ctrl key and click on the rows you want to delete. Then, right-click anywhere in the rows settings area. When the context menu opens, select the Move option.

Time Row Validation

The Date and GMT must be set; Time is optional. You do not need to set both limits — you can specify only the end date until which the row will be valid or only the start date from which it will be valid.

By default, all rows are not time-limited and will always be evaluated. If time validation is set, the row will only be evaluated within the specified period.

Debug

Debug mode is used to highlight the rows in the table that match the input. Rows that pass are displayed with a bolder border. Additionally, operators are highlighted in green if they match the input, or red if they do not. The input value for each condition column is also shown to the left of the operator, making it easy to see which conditions have passed or failed and why.

Additional Options

Default Row

This option adds a default row with ELSE conditions at the end of the table. This row is evaluated if no other rows match the input.

Check Table for Duplicates

This feature only works on the input values, as the output values can be identical.

Search

The Search option in the Settings menu allows you to search through the entire table and highlights the cells that match your input. To use this feature, select the Search option, and a search bar will appear:

Start typing the value you want to find. The cells that match will be highlighted in green. The search bar will display the number of rows that contain matches (not the number of matched cells). You can navigate between the matched rows using the arrow buttons.

Go to Row

In large tables, scrolling to a specific row can be challenging. The Go to Row option helps you quickly navigate to the desired row. Click this option, and a bar will appear where you can type the number of the row you want to go to, then press Enter. The table will scroll to that row, and the row settings area will be highlighted in green.

AutoSave Button

Highlight Active Columns and Rows

Choose whether you want to highlight rows, columns, or both, and activate the option. The selected row or column will be highlighted in light green, as demonstrated in the picture below.

Rule History & Undo/Redo

By clicking on a version tile, you can preview that version.

Restoring a version creates a new version — you will not lose your current version when restoring an older one.

After each change, press the button in the bottom right corner to save your progress.

More information is in the .

Each column has a column alias, a unique identifier within the scope of the table. You can use the alias to reference the column when using the feature or when binding column in an .

For more information about other column dropdown options, refer to the section.

A row represents one rule for specified data. If it's called, the or the with Input Data corresponding to conditions in a row, the or the response will have the same data specified in results in the corresponding row.

To add a new row, click the button in the bottom panel. This will create a new row at the end of the table with ANY condition operators.

Possible operators are specified in section

Function: Used for advanced operations, including logical functions (e.g., AND, OR), mathematical functions (e.g., ABS, MAX) and others, see the whole list in . The function operator can handle everything the Simple Value operator can, but also allows the use of more complex functions.

Read more in section.

Possible values for data types are specified in section.

For longer values, you can use the maximize mode. To do this, hover over the cell and click icon. This will open the maximized mode:

Input variable

Output variable

Rule variable

Calculation variable

To copy a row, click the button at the beginning of the row. Then, select the "Copy" option. The row will be duplicated with the same set of rules as the original.

To clear all sets of conditions and result values, click the button at the beginning of the row. Then, select the "Clear row" option. This will remove all values from the row.

To Inactive the row, toggle the switch at the beginning of the row.

To delete a row, click the icon at the beginning of the row and select the "Delete Row" option.

To use a row in the Test Bench click the button. Then, the row's condition columns values are copied to the Test Bench input at the bottom of the page, and the solution is evaluated as if you had clicked the Run button.

To change the position of the row, click the button. Then, select Move option. This will open a modal, where you can specify the new position of selected row.

You can specify in which time period the row will be active. To set the time validation, click the icon and then choose the Time validation option. A modal will appear, allowing you to select a From and To time range.

Once time validation is set for one row, the icon will appear next to the other rows. You can then click this icon to set time validation for another row directly, without needing to go through the context menu.

The Debug button is located on the at the bottom of the table designer. By default, debug mode is turned off. Clicking this button enables debug mode.

Additional functionality can be accessed by clicking the icon on the bottom bar. Here are the available options:

To check the table for duplicate rows, click the button in the bottom panel, then choose the option. This action compares the input values in the table. If any duplicate rows are found, they will be highlighted.

The AutoSave button is located at the bottom of the Decision Tables page, next to the / button. When the AutoSave button is active, the table is automatically saved after each solve in the Test Bench.

If you find it difficult to navigate between columns and rows, you can use the option to highlight active rows and columns. This function is available under the button in the navigation toolbar at the bottom of the Decision Tables page.

Every change made in this designer is recorded in a local history. You can undo or redo changes by clicking the or buttons.

To view the rule history, click the button located on the bottom bar. This opens a side menu with all available versions, where a new version is created every time you save the rule.

This action does not overwrite your current version; it is only a preview. If you want to restore an older version, click the icon on the top-right corner of the version tile.

Binding To Model
Table Operations
Rule Solver
Test Bench
Rule Solver
Test Bench
Operators
Functions section
Data Types
valid values
Test Bench
XLSX file
included/excluded condition column
Math function
Calculation variables
Column alias
Row validation from 29 April 2022 00:00:00 GMT+2 to 30 April 2022 23:59:59 GMT+2
Debug mode
Duplicate rows