Operators

Version:
Current
Last modified: September 21, 2020

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.

Block Comment

/*Comment*/: Use a block comment operator to add a comment block to an expression editor (within the expression line) without interfering with the expression.

Single Line Comment

// Comment: Use the single line comment operator to add a single-line comment to an expression editor without interfering with the expression.

Addition

Addition +: Use the addition operator to add multiple numeric values together. 

Boolean Operators

Boolean AND &&: (Boolean AND) Use this operator to combines 2 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) Use this operator to combines 2 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 are true, it returns True.

Boolean OR ||: (Boolean OR) If either (or both) of the two values are true, it returns True.

Close Parenthesis

Close Parenthesis ): Close Parenthesis

Division

Division /: Use the division operator to divide a numeric value by another numeric value.

Equal To

Equal To =: Equal To

Greater Than Operators

Greater Than >: Greater Than

Greater Than Or Equal >=: Greater Than Or Equal To

Less Than Operators

Less Than <: Less Than

Less Than Or Equal <=: Less Than Or Equal

Multiplication

Multiplication *: Use the multiplication operator to multiply multiple numeric values together.

Not Equal To

Not Equal To !=: Not Equal To

Open Parenthesis

Open Parenthesis (: Open Parenthesis

Subtraction

Subtraction -: Use the subtraction operator to subtract a numeric value from another.

Value IN Operators

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?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support.