BitwiseOr / Logical Layer

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

Example (with binary representation):

IndexLeftRightBitwise OR
06 (110)5 (101)7 (111)
13 (011)4 (100)7 (111)
2null5 (101)null
38 (1000)7 (111)15 (1111)

Common applications:

  • Flag combination
  • Permission merging
  • State combination
  • Bit pattern union
  • Feature flag merging
Table
0
0
Table

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

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

  • Base flags and additional flags
  • Current state and new bits
  • Multiple permission sets

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.