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.

 

Inputs

One.

 

Options

Select the two columns you wish to compare as Column 1 and Column 2.

 

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 case and whitespace sensitive. You can use Case to change the case, Trim 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 also

Split Cols