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.