Filters allow you to remove specific records from your dataset. You can add a filter to your recipe by clicking the Filter rows option in the toolbar as shown below:
The Filter rows toolbar option reveals all of the filter tasks that Trifacta supports. You can use the tasks shown in the dropdown menu to filter your data based on any of the following conditions:
Remove rows that contain mismatched data in a specified column
Remove rows that contain missing data in a specified column
Remove rows where a column value exactly matches a particular string
Remove rows where a column value is greater than (or equal to) a particular number
Remove rows where a column value is less than (or equal to) a particular number
Remove rows where a column value is not a particular string
Remove rows where a column value is one of a list of strings
Remove rows where a column contains a specific string or pattern
Remove rows where the data in a column begins with a specific string or pattern
Remove rows where the data in a column ends with a specific string or pattern
Remove duplicate rows
Remove rows from top
Remove rows in range
Remove rows at a regular interval
Remove rows based on a custom formula
Once you select a task from the dropdown menu, you can configure the task in the Transform Builder.
More Information
For product help and specific questions, check out the Trifacta Community
More details on filtering can be found in our product documentation