Table Splitter

The Table Splitter splits the input table at the row that matches a given condition. The part of the table that occurred before the matching row is forwarded to the top output table. The bottom output table contains the rest of the input table.

Options

Find splitting row by

Select if the table should be split at the first matching row or at the last matching row.

Lookup column

Select the column that should be used to evaluate the matching criteria. Only columns of type String, Number (integer), or Number (long) can be selected.

Matching criteria

Select criteria for matching the row:

• Equals: compares the value of the cell to a given search pattern.
• Missing: only matches rows that have a missing value at the selected column.
• Empty: matches rows that have an empty or missing value at the selected column. Strings and RowIDs containing only whitespace characters will also match.

Search pattern

Select a search pattern to compare the value of the selected column. If a number column is selected the search pattern must be a parsable number.

Include matching row in top output table

Select this option to include the row that split the table in the top output table.

Include matching row in bottom output table

Select this option to include the row that split the table in the bottom output table.

Update domains of all columns

Advanced setting to enable recomputation of the domains of all columns in the output table such that the domains' bounds exactly match the bounds of the data in the output table.

Views

This node has no views

Workflows

• 01_test hubKNIME Hub
• 20231103_acc_MMKNIME Forum
• Automate Away - webinar demo workflowKNIME Hub
• Charts and SpreadsheetsKNIME Hub
• Charts and Spreadsheets (short)KNIME Hub
• Show all 22 workflows

Links

• No links available

Developers