Math: Bitwise Functions

Version:
2019.3
Last modified: October 29, 2019

A bitwise function operates on one or more bit patterns or binary numerals at the level of their individual bits. Use a bitwise function to manipulate values for comparisons and calculations. Bitwise functions can only be used with Number data types.

BinaryAnd(n,m): Returns a binary of n and m. The result is 1 if both n and m are 1, and 0 otherwise. If 0 is equated with false, and 1 with true the BinaryAnd operation works like a logical And.

Example

BinaryAnd(1,1) returns 1

BinaryAnd(1,0) returns 0

BinaryNot(n): Returns a Binary Not of n

Example

BinaryNot(6) returns -7

BinaryNot(2) returns -3

BinaryOr(n,m): Returns a Binary Or of n and m

Example

BinaryOr(6,6) returns 6

BinaryOr(6,2) returns 6

BinaryXOr(n,m): Returns a Binary XOr of n and m

Example

BinaryXOr(6,6) returns 0

BinaryXOr(6,2) returns 4

ShiftLeft(n,b): Left shifts n (as integer) by b bits

ShiftRight(n,b): Right shifts n (as integer) by b bits

Was This Helpful?

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