Page tree



Contents:

The cloud-based version of Trifacta Wrangler is now available! Read all about it, and register for your free account.

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.

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

Your Rating: Results: 1 Star2 Star3 Star4 Star5 Star 11 rates

This page has no comments.