You can add a filter to your transformation view to remove rows from the dataset based on column values.
To add a filter:
- Select Transformation views from the left-side panel.
- Select a dataset from the list.
- Select Detail filter .
The filter properties display in the Detail filter panel on the right. - Select from the Show items that match dropdown if you want to show items that match All or Any of the filters you set.
- Select a column you want to filter from the Select column dropdown.
- Select the condition of the filter from the Select condition dropdown.
- If a field displays after you select a condition, enter the condition value.
- Select Save and then select Apply.