Use the Select or Exclude filters

Pentaho Data Integration
Version
9.3.x
Audience
anonymous
Part Number
MK-95PDIA003-15

In Stream View, you can use the Select filter to search a list of values for a field and then choose the values to apply. Alternately, you can use the Exclude filter to search a list of values for a field and then choose values to omit.

The search method you use to find values can be performed manually from the list of available values or by using the search box to narrow the choices in longer lists. The following illustration shows the features of the Select filter:


Select Filter Features

In the table below, use the preceding illustration to reference the features of the Select and Exclude filters.

Item Feature Description
1 Filter type Shows the name of the current filter, for example Select or Exclude.
2 Left pane*

Shows the values available for the Select or the Exclude filter, and includes:

  • The Search box that you can use to find, according to the entered character pattern, a specific value or values in the Filter field data. Search produces sorted results and is useful when working with large amounts data.
  • The number of available values, as indicated. Up to 25 available values are loaded at a time.

Highlight the values that you want to use for the filtering action and then move them to the right pane.
3 Right pane*

Shows the values added, which determines the filtering action of the Select or the Exclude filter, and includes:

  • The number of values added, as indicated from a maximum of 50.

If you have values that you do not want to use for the filtering action, highlight and then move them to the left pane.
4 Move icons

Use to add or remove values from the right pane, where:

  • Single greater than icon (>) adds the highlighted value.
  • Single less than icon (<) removes the highlighted value.
  • Double greater than icon (>>) adds all the values.
  • Double less than symbol (<<) removes all the values.

*Single and multi-select actions are supported: Use double-click to move single values; CTRL click to highlight multiple individual values; and, SHIFT click to highlight a range of values.