Select filter example

Pentaho Data Integration
Version
9.3.x
Audience
anonymous
Part Number
MK-95PDIA003-15
In this example, you want to identify the names of specific contacts in your dataset using the Select filter.
  1. From the Available Fields list, drag the CONTACTLASTNAME field to the Filters panel.


    Select Filter Example

    The Filter menu automatically displays.
  2. Choose the Select filter to produce a list of contact names in the left pane and then enter characters and character patterns in the Search box to find contact names that contain those characters in the database.


    Search Box Entry Example

    The left pane displays names that result from your search.
  3. Add the names you want to use for filtering by highlighting and moving them to the right pane. Continue searching for names and add them to the right pane. You can add up to 50 names.


    Select Filter Value Selections

    These names are the values that will be used for the Select filter.


    Exceeded Selection Indication

  4. If needed, refine the list of names already chosen. Note that the Apply button is enabled when any values are ready to be used as the Select filter.


    Value Removal Example

  5. Click Apply to proceed with filtering when your list is complete or the maximum number of values has been added.


    Select Filter Limit

    The table updates to only show the selected contact names.