Filter functions

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

The filters used in data inspection and their applicability are described in this section.

Filtering is an important tool for exploration and analysis when inspecting your data. You can explore your data in the inspection canvas by applying filters and then viewing the results in the visualization. See Use Filters to Explore Your Data for general information about filters.

Depending upon the viewing mode and specific field type, the following filtering functions are available as detailed in the table below.

Note: Filters on numeric values in Stream View are applied in the aggregated values or in row level values, depending on the drop zone type (if any) of the filtered field.
Note: Numeric filters in Model View are only available when other field types are present in the drop zones, and these filters are cleared when non-numeric fields are removed from the drop zones or when the visualization changes.
Filter Name Description and Use

Stream View

Filter Panel Field Types

Model View

Filter Panel Field Types
All All field data values are retained. Any Any
Select

Field data values are filtered using up to 50 selected values, to only retain data that contains the specified selections.

Note: Search functions are not case-sensitive.
 String, Boolean, and binary values N/A
Exclude

Field data values are filtered to omit up to 50 values, to only retain data that does NOT contain the specified selections.

Note: Search functions are not case-sensitive.
 String, Boolean, and binary values N/A
Contains

Field data values are filtered according to the entry in the Value field, to only retain data containing the specified numeral(s) and / or letter(s).

Note: When filtering, the comparison is case-sensitive.
 String and binary values Non-measure values
Does not contain

Field data values are filtered according to the entry in the Value field, to only retain data not containing the specified numeral(s) and / or letter(s).

Note: When filtering, the comparison is case-sensitive.
 String and binary values Non-measure values
Equals

Field data values are filtered according to the entry in the Value field, to only retain data equal to the specified amount.

Note: The value entered is validated, and then the filter is created only if the value is valid.
 Numeric values Measure values

Field data values are filtered according to the entry in the Value field, to only retain data equal to the specified value.

Note: When filtering, the comparison is case-sensitive.
 String and binary values Non-measure values
Does not equal

Field data values are filtered according to the entry in the Value field, to only retain data not equal to the specified amount.

Note: The value entered is validated, and then the filter is created only if the value is valid.
 Numeric values Measure values

Field data values are filtered according to the entry in the Value field, to only retain data not equal to the specified value.

Note: When filtering, the comparison is case-sensitive.
 String and binary values Non-measure values
Greater than Field data values are filtered according to the threshold entered in the Value field, along with the or equal to checkbox, to only retain data greater than (and, if selected, equal to) the specified value. Numeric values Measure values
Less than Field data values are filtered according to the threshold entered in the Value field, along with the or equal to checkbox, to only retain data less than (and, if selected, equal to) the specified value. Numeric values Measure values
Null Field data values are filtered to only retain data that includes (or excludes) null values (Show only or Exclude selection, respectively). Any Non-measure values