An attribute filter works in one of the four types. The filter type can be configured via Filter Type. For all filter types, Column must be specified. Filtering is based on attribute values from that column.
A pattern filter keeps the data items that match the given patterns. Each pattern is a string or a regular expression. Choose a Mode to define how patterns are matched against:
An extremum filter finds the data items that have the maximum or minimum value(s) in the filtered column. Use Criterion to choose from a Maximum or a Minimum filter.
The attribute filter chooses a comparator automatically based on the column type of the input data. Strings are compared by lexicographical order. Dates are compared by their POSIX values. Otherwise a numerical comparator is used.
A pattern filter always converts values to strings and uses string comparators.
Configures the filter type used. See filter types.
Configures the column on which filtering is applied.
Configures the filter mode that defines how attribute values are matched against patterns.
|Substring||The attribute value contains the pattern as a substring|
|Full String||The attribute value equals the pattern|
|Regular Expression||The pattern as a regular expression matches the attribute value|
Configures the pattern filter to use case-sensitive substring or full string matching.
The number of data items to keep based on the Amount Type given.
If Group By Column is given, data items are first grouped based on their attribute values. Filtering is then applied on each group separately.