Date: Sat, 29 Jan 2022 07:32:36 +0000 (GMT) Message-ID: <1697416652.127556.1643441556460@9c5033e110b2> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_127555_913457555.1643441556460" ------=_Part_127555_913457555.1643441556460 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html EXAMPLE - Logical Functions

EXAMPLE - Logical Functions

This example demonstrate the  ANDOR, and  NOT logical functions.

In this example, the dataset contains results from survey data on two qu= estions about customers. The yes/no answers to each question determine if t= he customer is 1) still active, and 2) interested in a new offering.

Functions:

=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20
Item Description
AND Function Returns true if both arg= uments evaluate to true. Equivalent to the && operator.
OR Function Returns true if either a= rgument evaluates to true. Equivalent to the || o= perator.
NOT Function Returns true if the argu= ment evaluates to false, and vice-versa. Equivalent to the ! operator.

Source:

=20 =20 =20 =20
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 cal= l:

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20
Transformation Name <= code>New formula Single row formula AND(isActive, isInterested) 'phoneCall'
=20

Customers that are either active or interested should receive an email:<= /p>

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20
Transformation Name <= code>New formula Single row formula OR(isActive, isInterested) 'sendEmail'
=20

Customers that are neither active or interested should be dropped from c= onsideration for the offering:

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20
Transformation Name <= code>New formula Single row formula AND(NOT(isActive),NOT(isInterested)= 'dropCust'
=20

A savvy marketer might decide that if a customer receives a phone call, = that customer should not be bothered with an email, as well:

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20
Transformation Name Edit column with formula sendEmail IF(phoneCall =3D=3D "TRUE", FALSE, sendEma= il)
=20

Results:

=20 =20 =20 =20 =20 =20 =20
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

=20
=20