> ## Documentation Index
> Fetch the complete documentation index at: https://www.domo.com/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Filtering Columns in Workbench 5

You can use the **Filter** transform to apply filters to a selected column. You can choose to have Workbench return matches or non-matches for the specified filter query. You can also include or exclude blank cells in your filtered data.

<Frame>
  <img alt="wb5_transforms_filter.png" src="https://mintcdn.com/domoinc/zA4JRrC5dgmG44ux/images/kb/ka05w00000123sy-00N5w00000Ri7BU-0EM5w000005vPP6.png?fit=max&auto=format&n=zA4JRrC5dgmG44ux&q=85&s=c04476baf29ae2cbfa5a7b650aa6f063" width="600" height="450" data-path="images/kb/ka05w00000123sy-00N5w00000Ri7BU-0EM5w000005vPP6.png" />
</Frame>

You can use regular expressions in building filter queries, just as you can when using the **Search & Replace** filter. Currently no Regular Expression Builder is available for helping you build filters as it is with **Search & Replace**; however, you can use all of the same constructions when building filter queries. For more information about the **Search & Replace** Regular Expression Builder, see [Replacing a Column Value in Workbench 5.](/docs/s/article/360043437433)

**To filter data in Workbench 5,**

1. In Workbench, Click <i className="legacy-icon-database sm" aria-hidden="true" /> in the left-hand icon bar.
2. In the Jobs listing, double-click the DataSet job with columns you want to filter.
3. Click
   **Transforms** to expand that section of the pane.
4. In the
   **Add a transform** menu, select **Filter Transform**.
5. Click the
   <img src="https://mintcdn.com/domoinc/zA4JRrC5dgmG44ux/images/kb/ka05w00000123sv-00N5w00000Ri7BU-0EM5w000005vPOn.png?fit=max&auto=format&n=zA4JRrC5dgmG44ux&q=85&s=f4c21f24bb2c1b751d294f2d3d6d6ca8" style={{width: 20, height: 20, display: 'inline', verticalAlign: 'start', margin: '0'}} width="33" height="34" data-path="images/kb/ka05w00000123sv-00N5w00000Ri7BU-0EM5w000005vPOn.png" /> button.

   The **Filter Transform Editor** appears.
6. In the
   **Search Column** menu, select the column you want to filter.
7. In the
   **Include Filter** field, enter your filter query.
8. (Conditional) If you want to prevent blank cells from appearing in your filtered column, set
   **Exclude Null** to **On**. Otherwise leave this off.
9. (Conditional) If you want your filter to return non-matches for your query, set
   **Exclude Matches** to **On**. Otherwise leave this off.
10. Click
    **Apply**.
11. Click the save icon <i className="icon-save sm" aria-hidden="true" /> at the top of the pane to save your transform.
