BitwiseAnd / Logical Layer

Create a column by applying bitwise AND operation element-wise between two numeric columns. Similar to numpy bitwise_and() or R's bitwAnd(). Performs binary AND on each bit position.

Example (with binary representation):

IndexLeftRightBitwise AND
06 (110)5 (101)4 (100)
13 (011)7 (111)3 (011)
2null5 (101)null
38 (1000)7 (111)0 (000)

Common applications:

  • Flag combination checking
  • Permission verification
  • Hardware register operations
  • Binary protocol handling
  • Bit mask filtering
Table
0
0
Table

The first numeric column for the bitwise AND operation. Values are treated as binary numbers. Null values result in null output.

The second numeric column for the bitwise AND operation. Must be same type as SelectLeft. Common pairs:

  • Values and masks
  • Flags and filters
  • Raw data and bit patterns

Name for the new column. If not provided, the system generates a unique name. If AsColumn matches an existing column, the existing column is replaced. The name should follow valid column naming conventions.