Operators specify what happens to the values on either side of the operator.
Transformer supports mathematical operators and string concatenate operators. It also supports logical operators and comparison operators, but only in an if-then-else conditional construct.
Operators | Description |
Perform mathematical operations. | |
Returns True if the conditions on both sides are true. | |
Returns True if either of the two conditions on both sides is true. | |
Returns True if the condition is false. | |
Concatenate two strings together. |
Performs mathematical operations. The precedence for processing mathematical operators is as follows:
exponents (^)
multiplication (*) and division (/)
addition (+) and subtraction (-)
Mathematical operators that are at the same level of precedence are evaluated from left to right. You can use parentheses to override this order of precedence.
Returns True if the conditions on both sides are true.
Salary < 60000 and Dept = 'Sales'
Retrieves the data where salary is less than $60,000 in the Sales department. Precedence is given to logical operators.
Returns True if either of the two conditions on both sides is true.
Name = 'Smith' or Name = 'Wong'
Retrieves the data for the names Smith and Wong.
Returns True if the condition is false.
not ( "STATE" <> 'CA' )
Returns True for all states that are not California.
Concatenates two strings together.
Char1 + Char2
FirstName + LastName
Combines FirstName and LastName without spaces between.
Comparison operators compare two values and produce the logical value True or False.
Operators | Description |
Compares two values. | |
Determines if a value is undefined in the data. |
Compare two values.
Value1 [=,<,>,<=,>=] Value2
Qty < 100
If the quantity is less than 100, evaluates to True and retrieves only those rows.
Price > 1000 or Qty <= 3
If the price is greater than 1000 or the quantity is less than or equal to 3, evaluates to True and retrieves only those rows.
Determines if a value is undefined in the data.
abc isnull
Telephone Number isnull
If there are no telephone numbers, evaluates to True. Retrieves only the rows missing telephone numbers.