LogicalAnd / Operator Layer
Perform logical AND operation between boolean columns or with a constant boolean value. Similar to pandas df['A'] & df['B'], numpy.logical_and(), or R's & operator.
Truth table:
| A | B | A AND B |
|---|---|---|
| true | true | true |
| true | false | false |
| false | true | false |
| false | false | false |
| null | any | null |
Common applications:
- Combining multiple conditions (valid & active)
- Multi-criteria filtering (in_stock & on_sale)
- Security checks (authenticated & authorized)
- Quality validation (tested & passed)
- Status verification (enabled & available)
- Complex rule evaluation (meets_age & has_consent)
Note: Follows standard boolean logic with three-valued logic for nulls.
Table
0
0
Table
SelectLeft
columnThe primary boolean column for AND operation. Must contain boolean values. Forms the first condition in logical combinations (e.g., is_valid, has_access).
SelectRight
oneofValue
boolBoolean constant for AND operation. Use cases:
- Conditional disabling (status & false)
- Feature gating (feature & true)
- Flag resetting (flag & false)
- State preservation (state & true)
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.