Row Filter

The node filters an input table according to the given filter criteria. Each criterion can target the row number, RowID, or cell value of a row. Multiple criteria can be combined (similar to boolean logic via AND and OR) to specify the overall filter criterion applied to each row.

Options

Match row if matched by

Match the row if all or any criteria match:

• All criteria: a row is matched if all of the criteria match (intersection of matches)
• Any criterion: a row is matched if at least one of the criteria matches (union of matches)

Filter criteria

The list of criteria that should be filtered on.

• Filter column: The column on which to apply the filter.
  The special column "RowID" represents the RowID of the input and is treated as a String column that is never missing. The special column "Row number" targets the 1-based row number of the input, is treated as a Long column and is never missing. Both special columns are always available, regardless of the input table spec or data.
  
  Columns containing data types that are non-native, i.e. contain cells of heterogeneous data types, or do not offer a conversion from and to a string representation are not supported and are filtered out from the available options.
  Collection columns are also not supported by the node.
• Operator: The operator determines whether a value meets the filter criterion. A value matches the criterion if the applied operator returns "true" and does not match if it returns "false." Not all operators are compatible with every column data type. Only the applicable operators are shown for the selected column.
  
  Missing value handling: The "is missing" and "is not missing" operators are available for all data types. Most other operators do not evaluate on missing values and will not match if a missing cell is encountered. An exception is the "is not equal" operator, which matches missing cells because they cannot equal the reference value. To exclude missing cells in this case, use the "is not equal (nor missing)" operator. "RowID" and "Row number" special columns are never missing.
  • Equals: Value in column must be equal to the specified reference value. Equality is define by the particular data type(s) involved and may be on the value's string representation.
  • Is not equal (nor missing): Value in column must be not equal to specified reference and also not missing.
  • Is not equal: Value in column must be not equal to specified reference value but can be missing.
  • Less than: Value in column must be strictly smaller than specified value.
    This operator is applicable for all data types that offer a more meaningful ordering than just lexicographic ordering. In particular, this includes by default numeric types and Date & Time types. String and Boolean types are not supported. The same requirements apply to the other ordering-based operators: "Less than", "Less than or equal", "Greather than", and "Greater than or equal".
  • Less than or equal: Value in column must be smaller than or equal to specified value
  • Greater than: Value in column must be strictly larger than specified value
  • Greater than or equal: Value in column must be larger than or equal than specified value
  • First n rows: Matches the specified number of rows counted from the start of the input.
  • Last n rows: Matches the specified number of rows counted from the end of the input.
  • Matches regex: Value in column must match the specified regular expression.
    This operator is applicable to all data types that are string-compatible, i.e. offer a meaningful string representation of themselves, or integral numbers. In particular, this includes Date & Time types. The same requirements apply to the "Matches wildcard" operator.
    
    Regex matching behavior: By default, the regex pattern must match the whole cell value, not just parts of it, since the regex pattern is configured with the DOTALL and MULTILINE flags enabled. To disable the DOTALL flag, prefix the pattern with (?-s), to disable MULTILINE use prefix (?-m). To disable both, use (?-sm).
  • Matches wildcard: Value in column must match the specified pattern, which may contain wildcards * and ?.
  • Is true: Boolean value in column must be true
  • Is false: Boolean value in column must be false
  • Is missing: Value in column must be missing
  • Is not missing: Value in column must not be missing
• Filter value: The value for the filter criterion.
  
  Note: Currently, comparison values for non-numeric and non-string data types, e.g. date&time-based types, must be entered as its string representation like in the Table Creator node.
  The format for date&time-based values is "ISO-8601 extended". For example, a "Local Date" must be entered in the format "2006-07-28". More information can be obtained from the ISO patterns in the "Predefined Formatters" table of the Java SE 17 documentation.

Column domains

Specify whether to take domains of all input columns as output domains as-is or compute them on the output rows.
Depending on the use case, one or the other setting may be preferable:

• Retaining input columns can be useful, if the axis limits of a view should be derived from domain bounds, and that bounds should stay stable even when the displayed data is filtered.
• Computing domains can be useful when a selection widget consumes the output and should only display actually present options to users.

If column domains are irrelevant for a particular use case, the "Retain" option should be used since it does not incur computation costs.
For more control over individual column domains, you can use the Domain Calculator, Edit Numeric Domain, or Edit Nominal Domain nodes.

• Retain: Retain input domains on output columns, i.e. the upper and lower bounds or possible values in the table spec are not changed, even if one of the bounds or one value is fully filtered out from the output table. If the input does not contain domain information, so will the output.
• Compute: Compute column domains on output columns, i.e. upper and lower bounds and possible values are computed only on the rows output by the node.

Filter behavior

Determines whether only matching or non-matching rows are output.

Views

This node has no views

Workflows

• [01] F1 - Download DataKNIME Hub
• [02] F1 - Circuit ProfileKNIME Hub
• 0.2 AirBnB DataKNIME Hub
• 00 Flow Variables - Supported TypesKNIME Hub
• 00 Send Reporting_vMediumKNIME Hub
• Show all 3579 workflows

Links

• No links available

Developers