Expression operators

You can use expression operators to construct mapping expressions that consist of more than a single input column.

SAP Cloud Integration for data services supports the following operators, listed in order of precedence:

Operator

Description

+

Addition

-

Subtraction

*

Multiplication

/

Division

=

Assignment, comparison

<

Comparison, less than

<=

Comparison, less than or equal to

>

Comparison, greater than

>=

Comparison, greater than or equal to

!=

Comparison, not equal to

||

Concatenate

%

Return the remainder when one number is divided by another

AND

Logical AND

OR

Logical OR

NOT

Logical NOT

IS NULL

Comparison, is a NULL value

IS NOT NULL

Comparison, is not a NULL value