Operators

Version:
2019.3
Last modified: October 09, 2019

An operator is a character that represents an action. Use an arithmetic operator to perform mathematical calculations or a Boolean operator to work with true/false values. Operators can be used with all data types.

/*Comment*/: Block Comment: Allows you to add comments to an expression editor (within the expression line) without interfering with the expression.

//Comment: Single Line Comment: Allows you to add comments to an expression editor without interfering with the expression.

Addition +: Addition

Boolean AND &&: Boolean AND: Used to combine two Boolean values. The result is also a Boolean value. The result is true if both of the combined values are true, and the result is false if either of the combined values is false.

Boolean AND - Keyword: Boolean AND: Used to combine two Boolean values. The result is also a Boolean value. The result is true if both of the combined values are true, and the result is false if either of the combined values is false.

Boolean NOT !: Boolean NOT: Accepts one input. If that input is TRUE, it returns FALSE. If that input is FALSE, it returns TRUE.

Boolean NOT - Keyword: Boolean NOT: Accepts one input. If that input is TRUE, it returns FALSE. If that input is FALSE, it returns TRUE.

Boolean OR - Keyword: Boolean OR:  If either (or both) of the two values it checks are TRUE, then it returns TRUE.

Boolean OR ||: Boolean OR:  If either (or both) of the two values it checks are TRUE, then it returns TRUE.

Close Parenthesis ): Close Parenthesis

Division /: Division

Equal To =: Equal To

Greater Than >: Greater Than

Greater Than Or Equal >=: Greater Than Or Equal

Less Than Or Equal <=: Less Than Or Equal

Multiplication *: Multiplication

Not Equal To !=: Not Equal To

Open Parenthesis (: Open Parenthesis

Subtraction -: Subtraction

value IN (...) - Keyword: Test Value in List: Determines if a given value matches any value in a subquery or a list.

value NOT IN (...) - Keyword: Test Value Not in List: Determines if a given value matches any value not in a subquery or a list.

Was This Helpful?

Need something else? Visit the Alteryx Community or contact support.