Not / Boolean Layer
Create boolean columns containing the logical NOT of input boolean columns. Similar to pandas ~series or numpy logical_not(). Inverts True to False and vice versa, while preserving nulls.
Common applications:
- Inverting conditions
- Creating opposite flags
- Negative condition testing
- Exception handling
- Reverse logic operations
Example:
Index | Input | Not |
---|---|---|
0 | true | false |
1 | false | true |
2 | null | null |
3 | true | false |
4 | false | true |
Table
0
0
Table
Transform
[, ...]List of boolean NOT operations to perform. Each transform creates a new boolean column. Common scenarios:
- Inverting multiple flags
- Creating complement conditions
- Negative state tracking
- Reverse indicator creation
At least one transform must be specified.
Select
columnThe boolean column to negate. The operation inverts all boolean values while preserving null values. True becomes False, False becomes True, null remains null.
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.