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 |
OR Function | Returns |
NOT Function | Returns |
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 | |
---|---|
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 | |
---|---|
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 | |
---|---|
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 | |
---|---|
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 |