Skip to main content

NOT Function

Returns true if the argument evaluates to false, and vice-versa. Equivalent to the ! operator.

  • The argument can be a literal Boolean, a function returning a Boolean, or a reference to a column containing Boolean values.

Since the function returns a Boolean value, it can be used as a function or a conditional.

Nota

Within an expression, you might choose to use the corresponding operator, instead of this function. For more information, see Logical Operators.

Wrangle vs. SQL: This function is part of Wrangle, a proprietary data transformation language. Wrangle is not SQL. For more information, see Wrangle Language.

Basic Usage

not(customerHappiness > 70)

Output: If the value in the customerHappiness column is not greater than 70, then the value is true. Otherwise, the value is false.

Syntax and Arguments

not(value1)

Argument

Required?

Data Type

Description

value1

Y

string

The value must be a Boolean literal, column reference, or expression that evaluates to true or false.

For more information on syntax standards, see Language Documentation Syntax Notes.

value1

Expression, column reference or literal that evaluates to a Boolean value.

  • Missing or mismatched values generate missing results.

Usage Notes:

Required?

Data Type

Example Value

Yes

Function or column reference returning a Boolean value or Boolean literal

myHeight > 2.00

Examples

Dica

For additional examples, see Common Tasks.

Example - Logical Functions

This example demonstrate the AND, OR, and NOT logical functions.

In this example, the dataset contains results from survey data on two questions about customers. The yes/no answers to each question determine if the customer is 1) still active, and 2) interested in a new offering.

Functions:

Item

Description

AND Function

Returns true if both arguments evaluate to true. Equivalent to the && operator.

OR Function

Returns true if either argument evaluates to true. Equivalent to the || operator.

NOT Function

Returns true if the argument evaluates to false, and vice-versa. Equivalent to the ! operator.

Source:

Customer

isActive

isInterested

CustA

Y

Y

CustB

Y

N

CustC

N

Y

CustD

N

N

Transformation:

Customers that are both active and interested should receive a phone call:

Transformation Name

New formula

Parameter: Formula type

Single row formula

Parameter: Formula

AND(isActive, isInterested)

Parameter: New column name

'phoneCall'

Customers that are either active or interested should receive an email:

Transformation Name

New formula

Parameter: Formula type

Single row formula

Parameter: Formula

OR(isActive, isInterested)

Parameter: New column name

'sendEmail'

Customers that are neither active or interested should be dropped from consideration for the offering:

Transformation Name

New formula

Parameter: Formula type

Single row formula

Parameter: Formula

AND(NOT(isActive),NOT(isInterested)

Parameter: New column name

'dropCust'

A savvy marketer might decide that if a customer receives a phone call, that customer should not be bothered with an email, as well:

Transformation Name

Edit column with formula

Parameter: Columns

sendEmail

Parameter: Formula

IF(phoneCall == "TRUE", FALSE, sendEmail)

Results:

Customer

isActive

isInterested

dropCust

sendEmail

phoneCall

CustA

Y

Y

FALSE

FALSE

TRUE

CustB

Y

N

FALSE

TRUE

FALSE

CustC

N

Y

FALSE

TRUE

FALSE

CustD

N

N

TRUE

FALSE

FALSE