Operators - trillium_discovery - 17.2

Trillium Expression Builder

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Quality
Trillium > Trillium Discovery
Version
17.2
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Expression Builder
Topic type
Administration
Overview
Installation
Reference
How Do I
Configuration
First publish date
2008
ft:lastEdition
2024-07-01
ft:lastPublication
2024-07-01T08:45:29.606589

The following table includes operator descriptions, syntax, and examples of use. Click the icon to view syntax and examples.

Guidelines

Note the following guidelines:

  • When you create an expression statement, if you construct the expression to return as TRUE (1) you can then drill down to see the rows that failed.
  • To add operators in the Expression Builder, you either click icon buttons or select from the list of expression elements.
  • Operators are not case sensitive.
  • Operator keywords are added to expressions in blue text.
  • When using literal values such as "New York," enclose the value in double quotation marks. Attribute names and numeric values do not require quotation marks. Any numeric value enclosed in quotation marks, such as "123" will be read as a literal value.
  • When using the Expression Builder in a Quality project, note the following:
    • Do not select "IF" to specify a condition. The "IF" part of the syntax is automatically generated.
    • There are a maximum of 100 nested IFs allowed in IF/ELSE conditional statements.
    • Adding multiple IF operators to the top level of a single conditional section is not supported. Include only one top-level IF (head-if) per section.
Operator Description
+ Sum of
- Subtract to find the difference of
* Multiplied by
/ Divided by
( Left parenthesis
) Right parenthesis
= Is equal To
<> Not equal To
< Less than
<= Less than or equal to
>= Greater than or equal to
> Greater than
AND

A conjunction between two statements. Both statements must be true for the conjunction to be true.

OR

An inclusive disjunction between two statements. At least one statement must be true for the disjunction to be true.

NOT

Reverses the truth value of the statement that follows, resulting in the opposite of the statement it evaluates.

IN

Tests whether a value is equal to a value in a list.

LIKE

Comparison operator that searches for a value that matches a specified pattern.

||

Concatenates multiple arguments (such as strings, attributes, and integers) with no space between each argument.

|:

Concatenates multiple arguments (such as strings, attributes, and integers) with a space between each argument.

IF,THEN, ELSE

Logical condition operators. The ELSE statement is optional. When using the Expression Builder inside a Quality project, do not select "IF" to specify a condition. The "IF" part of the syntax is automatically generated. 

IF, THEN, ELSE IF, THEN, ELSE

Logical condition operators. Syntax is similar to the IF, THEN, ELSE logical statement.