Compare Cols

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Compare Cols


Creates a new column with a comparison of two other columns.



Compare 2 numerical columns:


how to compare 2 numerical columns example


Compare 2 date columns:


how to compare 2 date columns example






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.

Comparisons of text are whitespace sensitive. You can use Whitespace to remove whitespace before filtering and Replace to get of other unwanted characters (e.g. whitespace inside the text).

The new column is added at the right end. You can change the column order with Reorder Cols and the column name with Rename Cols.

See here for more details on Regular expressions (regex).


See also

Split Cols