You can add a filter to your transformation view to remove rows from the dataset based on column values.

To add a filter:

  1. Select Transformation views from the left-side panel.
  2. Select a dataset from the list.
  3. Select Detail filter .
    The filter properties display in the Detail filter panel on the right.
  4. Select from the Show items that match dropdown if you want to show items that match All or Any of the filters you set.
  5. Select a column you want to filter from the Select column dropdown.
  6. Select the condition of the filter from the Select condition dropdown.
  7. If a field displays after you select a condition, enter the condition value.
  8. Select Save and then select Apply.