LogicalOr / Operator Layer
Perform logical OR operation between boolean columns or with a constant boolean value. Similar to pandas df['A'] | df['B'], numpy.logical_or(), or R's | operator.
Truth table:
| A | B | A OR B |
|---|---|---|
| true | true | true |
| true | false | true |
| false | true | true |
| false | false | false |
| null | true | true |
| null | false | null |
| null | null | null |
Common applications:
- Alternative conditions (cash_payment | card_payment)
- Error detection (timeout | connection_error)
- Access control (admin | moderator)
- Status checks (shipped | delivered)
- Alert triggers (high_temp | low_pressure)
- Validation rules (required | has_default)
Note: Implements short-circuit evaluation where possible (true OR x = true).
Table
0
0
Table
SelectLeft
columnThe primary boolean column for OR operation. Must contain boolean values. Forms the first condition in logical combinations (e.g., main_condition, primary_check).
SelectRight
oneofValue
boolBoolean constant for OR operation. Use cases:
- Force enabling (status | true)
- Default inclusion (filtered | false)
- Override flags (restricted | true)
- Fallback states (custom_setting | false)
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.