Depending on the data type, you can compare values in separate columns or single columns against fixed values.
You can use basic comparison operators to perform comparisons on your data. In this example, the compareCol column is generated as the evaluation of 3 < 6
, which is true
:
For more information, see Comparison Operators.
Boolean values can be true
or false
, so comparisons like the following can be applied to a Boolean set of values:
In the above case, the value in Attendance
is set to true
if the value in the isSeated
column is true
. Otherwise, the current value in Attendance
is used.
You can use the DATEDIF
function to compare two date values, as in the following, which compares the number of days between startCol
and endCol
values:
NOTE: Both parameters of the |
See DATEDIF Function.
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: