Or / Logical Layer
Create a boolean column by applying logical OR operation between two boolean columns. Similar to pandas |, SQL OR, or R's ||.
Truth table:
| Left | Right | Result |
|---|---|---|
| true | true | true |
| true | false | true |
| false | true | true |
| false | false | false |
| null | true | true |
| true | null | true |
| null | false | null |
| false | null | null |
| null | null | null |
Common applications:
- Alternative conditions
- Error catching
- Flag combinations
- Alert triggers
- Flexible filtering
Table
0
0
Table
SelectLeft
columnThe first boolean column for the OR operation. Forms the left side of the logical expression. True values override nulls in the result.
SelectRight
columnThe second boolean column for the OR operation. Forms the right side of the logical expression. True values override nulls in the result.
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.