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.