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.
NOTE: 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 |
Tip: For additional examples, see Common Tasks.
Examples
Example - Logical Functions
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 |
This page has no comments.