Saltar al contenido principal

Domo University Videos

Domo

Filtering Columns in Workbench 4

Important: When referencing this page outside of Knowledge Base, use this link: https://knowledge.domo.com?cid=wb4filter

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. 

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

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.

 

 

Note: The product training videos are for Domo customers and clients only.