Filter

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Filter

Description

Removes rows based on number, date and text values in selected columns.

 

Inputs

1.

 

Options

Click the '+' button to add a new filter criteria.

Click the 'x' button to delete the selected filter criteria.

Select Keep if you want to keep matching rows and Remove to remove matching rows.

Select Matching all to match on all criteria (e.g. criteria 1 and criteria 2). Select Matching any to require a match on one or more criteria (e.g. criteria 1 or criteria 2).

Set Column to the column you wish to match.

Set Op. to the comparison operator.

Set Value to the value you wish to compare.

 

Notes

Number, date and text values are treated differently for Is, Greater than, Less than, Greater than equal and Less than equal operations. Any values that can be converted to a number will be treated as a number. Any value that match the supported date formats in Preferences will be treated as a date.

All values are treated as text for Contains, Starts with, Ends with, Matches regex, Is not, Doesn't start with, Doesn't end with and Doesn't match regex operations.

Comparisons of text are case and whitespace sensitive. You can use Case to change the case and Trim to remove whitespace before filtering.

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