This example demonstrate the

`AND`

, `OR, 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 Parameter: Formula type `Single row formula`

Parameter: Formula `AND(isActive, isInterested)`

Parameter: New column name `'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 Parameter: Formula type `Single row formula`

Parameter: Formula `OR(isActive, isInterested)`

Parameter: New column name `'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 Parameter: Formula type `Single row formula`

Parameter: Formula `AND(NOT(isActive),NOT(isInterested)`

=
Parameter: New column name `'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`

Parameter: Columns `sendEmail`

Parameter: Formula ```
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

```
------=_Part_301_2023720001.1675920859946--
```