LogicalNot / Operator Layer
Perform logical NOT operation on a boolean column. Similar to pandas ~df['A'], numpy.logical_not(), or R's ! operator. Inverts boolean values while preserving nulls.
Truth table:
A | NOT A |
---|---|
true | false |
false | true |
null | null |
Common applications:
- Inverting conditions (not is_deleted)
- Exception cases (not in_stock)
- Status reversals (not active)
- Validation negation (not validated)
- Access restrictions (not authorized)
- Flag toggling (not enabled)
Note: Maintains three-valued logic with null values, following SQL semantics.
Table
0
0
Table
Transforms
[, ...]Select
columnThe boolean column (Select
) to negate. Common scenarios:
- Boolean flags (disabled = not enabled)
- Status indicators (unavailable = not available)
- Condition checks (invalid = not valid)
- Access control (denied = not allowed)
Must contain boolean values
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.