You can apply a filter to your aggregation to filter rows that you have already transformed with the aggregation.

Aggregate filters are only enabled when aggregation is enabled.

To apply an aggregate filter:

  1. Select Data Orchestrator from the top-left navigation menu.
  2. Choose a dataspace from the list.
  3. Select Transformation views from the left-side panel.
  4. Select a dataset from the list.
  5. Select Aggregate filter .
    The filter properties display in the Aggregate filter panel on the right.
  6. Select from the Show items that match dropdown if you want to show items that match All or Any of the filters you set.
  7. Select the aggregate column you want to filter from the Select column dropdown.
  8. Select the condition of the filter from the Select condition dropdown.
  9. If a field displays after you select a condition, enter the condition value.
  10. Select Save and then select Apply.