BitwiseXor / Logical Layer
Create a column by applying bitwise XOR operation element-wise between two numeric columns. Similar to numpy bitwise_xor() or R's bitwXor(). Performs binary XOR on each bit position.
Example (with binary representation):
| Index | Left | Right | Bitwise XOR |
|---|---|---|---|
| 0 | 6 (110) | 5 (101) | 3 (011) |
| 1 | 3 (011) | 3 (011) | 0 (000) |
| 2 | null | 5 (101) | null |
| 3 | 8 (1000) | 7 (111) | 15 (1111) |
Common applications:
- Change detection
- Error checking codes
- Toggle operations
- Parity calculation
- Bit difference detection
Table
0
0
Table
SelectLeft
columnThe first numeric column for the bitwise XOR operation. Values are treated as binary numbers. Null values result in null output.
SelectRight
columnThe second numeric column for the bitwise XOR operation. Must be same type as SelectLeft. Common pairs:
- Old and new values
- Expected and actual patterns
- Reference and test data
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.