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:

InputOutput
truefalse
falsetrue
nullnull

Common applications:

  • Inverting conditions
  • Exception handling
  • Exclusion filters
  • Negative conditions
  • Complement sets
Table
0
0
Table

Select

column

The 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.

Name 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.