Operators

Version:
Current
Last modified: June 26, 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*/: Block Comment: Allows you to add a comment block to an expression editor (within the expression line) without interfering with the expression.

Single Line Comment

//Comment: Single Line Comment: Allows you to add a single-line comment to an expression editor without interfering with the expression.

Addition

Addition +: Addition

Boolean Operators

Boolean AND &&: (Boolean AND) Combines 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) Combines 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 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 /: Division

Equal To

Equal To =: Equal To

Greater Than Operators

Greater Than >: Greater Than

Greater Than Or Equal >=: Greater Than Or Equal

Less Than Operators

Less Than <: Less Than

Less Than Or Equal <=: Less Than Or Equal

Multiplication

Multiplication *: Multiplication

Not Equal To

Not Equal To !=: Not Equal To

Open Parenthesis

Open Parenthesis (: Open Parenthesis

Subtraction

Subtraction -: Subtraction

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.