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 