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):
Index | Left | Right | Bitwise OR |
---|---|---|---|
0 | 6 (110) | 5 (101) | 7 (111) |
1 | 3 (011) | 4 (100) | 7 (111) |
2 | null | 5 (101) | null |
3 | 8 (1000) | 7 (111) | 15 (1111) |
Common applications:
- Flag combination
- Permission merging
- State combination
- Bit pattern union
- Feature flag merging
Table
0
0
Table
SelectLeft
columnThe first numeric column for the bitwise OR operation. Values are treated as binary numbers. Null values result in null output.
SelectRight
columnThe 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
AsColumn
nameName 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.