Depending on the data type, you can compare values in separate columns or single columns against fixed values.
Compare Numeric 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 You can paste Wrangle
steps into the Transformer Page.
3 < 6, which is
You can paste Wrangle steps into the Transformer Page.For more information, see Comparison Operators.
Compare Boolean Values
Boolean values can be
false, so comparisons like the following can be applied to a Boolean set of values:
Attendanceis set to
trueif the value in the
true. Otherwise, the current value in
Compare Date Values
You can use the
DATEDIF function to compare two date values, as in the following, which compares the number of days between
NOTE: Both parameters of the
DATEDIF function must be column references containing valid date values.
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.
- STRINGLESSTHAN Function
- STRINGLESSTHANEQUAL Function
- STRINGGREATERTHAN Function
- STRINGGREATERTHANEQUAL Function
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:
This page has no comments.