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:

ANOT A
truefalse
falsetrue
nullnull

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

column

The 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

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.