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

Did this answer your question?