Row Filter (deprecated)

The node allows for row filtering according to certain criteria. It can include or exclude: certain ranges (by row number), rows with a certain RowID, and rows with a certain value in a selectable column (attribute). Below are the steps on how to configure the node in its configuration dialog. Note: The node doesn't change the domain of the data table. I. e. the upper and lower bounds or the possible values in the table spec are not adapted, even if one of the bounds or one value is fully filtered out.

Options

In- or exclude rows by criteria

You must first select which criteria should be used for filtering from the left-hand side. Also choose whether to include or exclude rows according to the selected criteria. Depending on the choice, you will then have to adjust the filter parameters in the right-hand panel.

Column value matching

If filter by attribute value is selected, select the name of the column whose value should be matched. If the selected column is a collection column the filter based on collection elements option allows to filter each row based on the elements of the collection instead of its string representation. Then, either enter a pattern for string matching, or a value range, for range filtering. When using a pattern match, you can set checkmarks according to whether the pattern contains wildcards or is a regular expression. Wildcard patterns contain '*' (matching any sequence of characters) and '?' (matching any one character). Examples of regular expressions are given below. Also, a case sensitive match can be enabled by the according checkmark. Note: if you select a pattern from the drop-down menu of the pattern text field, the node still performs a comparison of the string representation of the data values.
If a range is specified, and you specify only one boundary, the other is then set to (plus or minus) infinity.
Here are some examples of regular expressions:
"^foo.*" matches anything that starts with "foo". The '^'-character stands for the beginning of the word, the dot matches any (one) character, and the asterisk allows any number (including zero) of the previous character.
"[0-9]*" matches any string of digits (including the empty string). The [ ] define a set of characters (they could be added individually like [0123456789], or by range). This set matches any (one) character included in the set.
For a complete explanation of regular expressions see e.g. the JavaDoc of the java.util.regex.Pattern class.

Row number range

If filter by range is selected, specify the first row number to in/exclude. The end of the range can either be specified by row number, or set to the end of the table, causing all remaining rows to be in/excluded.

RowID pattern

If filter by RowID is selected, specify a regular expression, which is matched against the RowID of each row. A checkmark can be set, if a case sensitive match should be performed and if the RowID should start with the specified pattern.

Views

This node has no views

Workflows

• Credit Scoring Model(diksha kumari)KNIME Hub
• justknimeit-27KNIME Hub
• _01_ChemicalLibraryEnumerationKNIME Hub
• _01_Network_Traffic_ReportingKNIME Hub
• _01_PMR_AnalysisKNIME Hub
• Show all 9246 workflows

Links

• KNIME E-Learning Course: Basic Row Filter

  www.knime.com/knime-introductory-course/chapter3/section1/basic-row-filter
• Selecting the top 50 rows of a table by a control columnby armingrudd on 2019-11-05

  forum.knime.com/p/74011
• [Feature suggestion] A Node that does Nothingby qqilihq on 2022-08-23

  forum.knime.com/p/167117
• Send Email with two loops/variables?by armingrudd on 2020-03-04

  forum.knime.com/p/83318
• How to keep only those rows containing a specific valueby armingrudd on 2019-07-03

  forum.knime.com/p/64302
• Show all 20 links

Developers