Date: Fri, 30 Sep 2022 05:36:00 +0000 (UTC) Message-ID: <1229802840.5336.1664516160237@93e1396c9615> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_5335_799098069.1664516160237" ------=_Part_5335_799098069.1664516160237 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html Compare Values

# Compare Values

=20

Contents:

=20

=20

=20
=20

Depending on the data type, you can compare values in separate columns o= r single columns against fixed values.

## Compare Numeric Values

You can use basic comparison operators to perform comparisons on your da= ta. In this example, the compareCol=  column is generated as the evaluation of `3 < 6`= , which is `true`:

=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` `(3 < 6)` `'compareCol'`
=20

## Compare Boolean Values

Boolean values can be `true` or `false`,= so comparisons like the following can be applied to a Boolean set of value= s:

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20
Transformation Name `Edit column with formula` `Attendance` `IF(isSeated =3D=3D true,true,Attendance)`
=20

In the above case, the value in `Attendance` is set to&n= bsp;`true` if the value in the `isSeated` column= is `true`. Otherwise, the current value in ```Atte= ndance``` is used.

## Compare Date Values

You can use the `DATEDIF` function to compare two date v= alues, as in the following, which compares the number of days between startCol and `endCol` values:

NOTE: Both parameters of the `DATEDIF` funct= ion must be column references containing valid date values.

=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` `DATEDIF(startCol, endCol, 'day')`=20 `'DurationInDays'`
=20

See DATEDIF Function= .

## Compare String Values

For string values, you can use the string comparison functions to check = how strings compare using Latin collation settings.

Tip: Any column can be converted to String data type to= use these functions.

Available functions:

For more information on collation, see String Collation Rules.

You can also use the following functions to evaluate sub-strings within = a string which can be compared to other values:

------=_Part_5335_799098069.1664516160237--