Icon

Row Splitter

The Row Splitter node is almost identical to the Row Filter node. The only difference between these two nodes is that the Row Splitter provides two output ports: one for TRUE matches and the second for FALSE matches.

For nodes with multiple output ports, you can view the results of each port in the Node Monitor by selecting the Port Output option. A small menu will appear where you can select from Port 0, Port 1, and so on. Ports are numbered in order from top-to-bottom.

The Row Splitter offers the following options for filtering records from a table.


1) Include/Exclude rows by attribute value: These two options allow you to include or exclude rows according to either a pattern, a range of values, or by missing value matching. To begin, select the column at the top of the configuration menu by which you will filter the table.

In general, pattern matching is used for string data types and range checking is for numeric data types. Further, the pattern matching option allows for wildcard and regular expression matching. Wildcard matching uses the * character, such as "New*" would match all states that begin with "New".


2.) Include/Exclude rows by row number: These two options allow you to include or exclude rows according to their row position in the table. This is useful if you with to include the first N records in a table, or exclude unneccessary records that are always in the same location. The end of the row filter can either be set manually or dynamically to the end of the table. The beginning of the row filter must be set manually.


3.) Include/Exclude rows by Row ID: These two options allow you to include or exclude rows according to their Row ID values. Every KNIME table has a Row ID field that is separate from the other fields in the table. By default, these have names like "Row0," "Row1," and so on (although these can be modified in various ways.

This option allows you to write a regular expression to include or exclude rows according to these Row ID values.

Row Splitter The Row Splitter node is almost identical to the Row Filter node. The only differencebetween these two nodes is that the Row Splitter provides two output ports: one forTRUE matches and the second for FALSE matches.For nodes with multiple output ports, you can view the results of each port in the NodeMonitor by selecting the Port Output option. A small menu will appear where you canselect from Port 0, Port 1, and so on. Ports are numbered in order from top-to-bottom.The Row Splitter offers the following options for filtering records from a table.1) Include/Exclude rows by attribute value: These two options allow you to include orexclude rows according to either a pattern, a range of values, or by missing valuematching. To begin, select the column at the top of the configuration menu by whichyou will filter the table. In general, pattern matching is used for string data types and range checking is fornumeric data types. Further, the pattern matching option allows for wildcard andregular expression matching. Wildcard matching uses the * character, such as "New*"would match all states that begin with "New".2.) Include/Exclude rows by row number: These two options allow you to include orexclude rows according to their row position in the table. This is useful if you with toinclude the first N records in a table, or exclude unneccessary records that are alwaysin the same location. The end of the row filter can either be set manually ordynamically to the end of the table. The beginning of the row filter must be setmanually.3.) Include/Exclude rows by Row ID: These two options allow you to include or excluderows according to their Row ID values. Every KNIME table has a Row ID field that isseparate from the other fields in the table. By default, these have names like "Row0,""Row1," and so on (although these can be modified in various ways. This option allows you to write a regular expression to include or exclude rowsaccording to these Row ID values. Include StateName values that match the wildcardexpression "New*" This returns all StateName values that start with theletters "New" and are followed by anything. Exclude StateName values that match the regularexpression (.*)(\s)(.*)This removes all StateName values that have aspace in them. Include row numbers 26 through the end of the table. Exclude records with Row IDs that match the regularexpression "Row\d{2}"That is, Row IDs like Row10, Row17, or Row33--anyrow with a two-digit value after the word "Row." Night Heron Data, 2023 Input some dataInclude rows byattribute value -pattern matchingExclude rows byattribute value -regular expressionInclude rowsby row numberSplit recordsby Row ID Table Creator Row Splitter Row Splitter Row Splitter Row Splitter Row Splitter The Row Splitter node is almost identical to the Row Filter node. The only differencebetween these two nodes is that the Row Splitter provides two output ports: one forTRUE matches and the second for FALSE matches.For nodes with multiple output ports, you can view the results of each port in the NodeMonitor by selecting the Port Output option. A small menu will appear where you canselect from Port 0, Port 1, and so on. Ports are numbered in order from top-to-bottom.The Row Splitter offers the following options for filtering records from a table.1) Include/Exclude rows by attribute value: These two options allow you to include orexclude rows according to either a pattern, a range of values, or by missing valuematching. To begin, select the column at the top of the configuration menu by whichyou will filter the table. In general, pattern matching is used for string data types and range checking is fornumeric data types. Further, the pattern matching option allows for wildcard andregular expression matching. Wildcard matching uses the * character, such as "New*"would match all states that begin with "New".2.) Include/Exclude rows by row number: These two options allow you to include orexclude rows according to their row position in the table. This is useful if you with toinclude the first N records in a table, or exclude unneccessary records that are alwaysin the same location. The end of the row filter can either be set manually ordynamically to the end of the table. The beginning of the row filter must be setmanually.3.) Include/Exclude rows by Row ID: These two options allow you to include or excluderows according to their Row ID values. Every KNIME table has a Row ID field that isseparate from the other fields in the table. By default, these have names like "Row0,""Row1," and so on (although these can be modified in various ways. This option allows you to write a regular expression to include or exclude rowsaccording to these Row ID values. Include StateName values that match the wildcardexpression "New*" This returns all StateName values that start with theletters "New" and are followed by anything. Exclude StateName values that match the regularexpression (.*)(\s)(.*)This removes all StateName values that have aspace in them. Include row numbers 26 through the end of the table. Exclude records with Row IDs that match the regularexpression "Row\d{2}"That is, Row IDs like Row10, Row17, or Row33--anyrow with a two-digit value after the word "Row." Night Heron Data, 2023 Input some dataInclude rows byattribute value -pattern matchingExclude rows byattribute value -regular expressionInclude rowsby row numberSplit recordsby Row ID Table Creator Row Splitter Row Splitter Row Splitter Row Splitter

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: johnemery
Created at: 2023-05-19
On NodePit since: 2023-05-21
Last update: 2024-05-02
Created with KNIME version: v4.7.2
Tags: row splitternode bitesnight heron data

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!