Navigation: Reference > Transforms >
Creates a new column with a comparison of two other columns.
Compare 2 numerical columns:
Compare 2 date columns:
•Select the two columns you wish to compare as Column 1 and Column 2 and the Comparison operator.
•Check case sensitive to use case sensitive matching for text.
•Number, date and text values are treated differently. Any values that can be converted to a number will be treated as a number. Any values that match the supported date formats in Preferences will be treated as a date. All other values are treated as text.
•See here for more details on Regular expressions (regex).