Operators

Version:
2021.3
Last modified: August 12, 2021

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 and false values. You can use operators with all data types.

Block Comment

/* */: Use a block comment operator to add a comment block to an expression editor (within the expression line) without interfering with the expression. For example, /*This is a block comment.*/.

Single Line Comment

//: Use the single-line comment operator to add a single-line comment to an expression editor without interfering with the expression. For example, //This is a single-line comment.

Addition

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

Boolean Operators

Boolean AND &&

&&: Use this operator to combine 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

AND: Use this operator to combine 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 !

!: Accepts 1 input. If that input is true, it returns False. If that input is false, it returns True.

Boolean NOT - Keyword

NOT: Accepts 1 input. If that input is true, it returns False. If that input is false, it returns True.

Boolean OR - Keyword

OR: If either or both of the 2 values are true, it returns True.

Boolean OR ||

||: If either or both of the 2 values are true, it returns True.

Close Parenthesis

): Close Parenthesis

Division

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

Equal To

=: Equal To

Greater Than Operators

>: Greater Than

>=: Greater Than Or Equal To

Less Than Operators

<: Less Than

<=: Less Than Or Equal

Multiplication

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

Not Equal To

!=: Not Equal To

Open Parenthesis

(: Open Parenthesis

Subtraction

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

Value IN Operators

Value IN (...) - Keyword

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

Value NOT IN (...) - Keyword

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

Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.