Date: Thu, 9 Feb 2023 05:34:19 +0000 (UTC) Message-ID: <1809450181.302.1675920859946@1323b43bed1d> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_301_2023720001.1675920859946" ------=_Part_301_2023720001.1675920859946 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 `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 formulaParameter: Formula typeSingle row formulaParameter: FormulaAND(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 formulaParameter: Formula typeSingle row formulaParameter: FormulaOR(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 formulaParameter: Formula typeSingle row formulaParameter: FormulaAND(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 NameEdit column with formulaParameter: ColumnssendEmailParameter: FormulaIF(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 See Also for EXAMPLE - Logical Functions:=20 =20 =20 Page:<= /span>=20 =20 AND Function=20 =20 =20 Page:<= /span>=20 =20 OR Function=20 =20 =20 Page:<= /span>=20 =20 NOT Function=20 =20 =20 =20 =20 =20 ```
``` ------=_Part_301_2023720001.1675920859946-- ```