Page tree

Release 9.2


Contents:

   

This example demonstrate the ANDOR, 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:

ItemDescription
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:

CustomerisActiveisInterested
CustAYY
CustBYN
CustCNY
CustDNN

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:

CustomerisActiveisInteresteddropCustsendEmailphoneCall
CustAYYFALSEFALSETRUE
CustBYNFALSETRUEFALSE
CustCNYFALSETRUEFALSE
CustDNNTRUEFALSEFALSE

See Also for EXAMPLE - Logical Functions:

This page has no comments.