Cell Validation

Each and every value entered in decision table is validated. If you enter or modify a value in the cell, a validation check is performed.

In case the validation check fails, cross mark appears in the right corner of the cell. When you hover over the cross mark, a tool tip with the reason for validation failure is displayed.

The following cell validations are performed:

  • Syntax Validation -The syntax validation is performed while entering multiple values. A comma delimiter must be used while entering multiple values.
  • Validation of values based on operator - The number of values entered in the text cell for a particular column depends upon the combination of type of operator used for that column and the variable (whether its multi-value or not). The table below shows the number of values required for various operators.

    Cell Validation

    Operator Number of Values required for multi-value attribute Number of Values required for Non multi-value attribute
    Eq * 1
    Contains * NA
    ContainsAll NA NA
    Customs NA NA
    In NA *
    Neq * 1
    Gt NA 1
    Lt NA 1
    Geq NA 1
    Leq NA 1
    Between NA 2
  • Validation of values as per the variable data type - After performing the Syntax and number of values validation, the variable data type validation is performed. The following date type formats are supported by decision table:
    • mm/dd/yyyy (default date format)
    • dd-mon-yyyy
    • mm/dd/yy
    • ddmmyyyy
    • yyyy-mm-dd
    • yyyy/mm/dd
    • dd-mm-yyyy
    • dd/mm/yyyy
    • dd-mm-yy
    • timestamp