Compare Cols

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Compare Cols

Description

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

 

Examples

Compare 2 numerical columns:

how to compare 2 numerical columns example

 

Compare 2 date columns:

how to compare 2 date columns example

 

Inputs

One.

 

Options

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.

 

Notes

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