Filter and Delete Rows

You can filter data and delete any rows that match (or do not match) the criteria during data preparation.

Select one or more cells in a column, click in the Create Transform bar, select Filter, and complete the formula as follows:
Filter values in [<Column>] ][<criterion>] "<values>"
Where:
  • <criterion> - Choose the criterion type on which to filter and delete rows:

    • matching - Matching any of the specified <values>

    • not matching - [default] Not matching any of the specified <values>

    • between - [numeric columns] Between the <from> and <to> values

    • matching null - Containing null values

    • not matching null - Containing any non-null <values>.

  • <values> - Enter the strings to match against, using commas to separate multiple values.