Not / Logical Layer
Create a boolean column by applying logical NOT operation to a boolean column. Similar to pandas ~series or SQL NOT.
Truth table:
| Input | Output |
|---|---|
| true | false |
| false | true |
| null | null |
Common applications:
- Inverting conditions
- Exception handling
- Exclusion filters
- Negative conditions
- Complement sets
Table
0
0
Table
Select
columnThe boolean column to negate. Performs logical inversion where:
- true becomes false
- false becomes true
- null remains null
Useful for creating opposite conditions or inverting filter masks.
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.