> ## Documentation Index
> Fetch the complete documentation index at: https://domoinc-openapi-sync-dataflows.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Filtering Columns in Workbench 4

<Warning>
  **Important:** Support for Workbench 4 ended on **April 15, 2021**. Workbench may continue to run on installed machines, but it will no longer receive feature enhancements and security updates. When issues are encountered in Workbench 4, the recommended course of action from the Domo Support team will be to upgrade to the latest version of Workbench 5. To see this article for Workbench 5, click [**here**](/s/article/360042932814).
</Warning>

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="wb4_transform_filter.png" src="https://mintcdn.com/domoinc-openapi-sync-dataflows/7Nd5Hb-h9pITriJg/images/kb/ka05w00000123qZ-00N5w00000Ri7BU-0EM5w000005vPKK.png?fit=max&auto=format&n=7Nd5Hb-h9pITriJg&q=85&s=ee6db588bc286f327374925f47602488" width="700" height="139" data-path="images/kb/ka05w00000123qZ-00N5w00000Ri7BU-0EM5w000005vPKK.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 4](/s/article/360046864274 "Replacing a Column Value in Workbench 4").

**To filter data in Workbench 4,**

1. In the
   **Accounts** pane, select the DataSet job in which you want to set filters.
2. In the
   **Transforms** grouping in the Buttons toolbar at the top of the Workbench window, click **Add New**.
3. In the
   **Transform Type** menu, select **Filter** then click **Next**.
4. Click
   **Finish**.

   A **Filter** item is added under **Transforms** for this DataSet job.
5. Click on the new
   **Filter** item under **Transforms**.

   A set of **Filter Data Transform** options appear in the Dynamic Options panel.
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
    **Save** in the **DataSet Jobs** grouping in the **Buttons** toolbar at the top of the Workbench window.

**Training Video - Adding a Filter Transform**

Learn how to apply filters to selected columns in Workbench 4 using a Filter transform.

<iframe allowfullscreen="" frameborder="0" height="315" src="//player.vimeo.com/video/412861754" width="560" />