Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Hub
  • Nodes
  • Row Splitter
NodeNode / Manipulator

Row Splitter

Manipulation Row Filter Streamable
Drag & drop
Like
Copy short link

This node has exactly the same functionality as the Row Filter node, except for that it has an additional output that provides the rows that are filtered out. For performance and disk space reasons you may want to consider using the Row Filter node. The table at the upper port (with index 0) contains the rows included in the result according to the filter criteria (the node settings). The lower port (with index 1) provides a table with all rows not matching the filter criteria. The sum of the number of rows in the two output tables is the same than the number of rows in the input table.
Following is a copy of the node description of the Row Filter node:
The node allows for row filtering according to certain criteria. It can include or exclude: certain ranges (by row number), rows with a certain row ID, 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.

Node details

Input ports
  1. Type: Table
    To be filtered
    Datatable from which to filter rows.
Output ports
  1. Type: Table
    Filtered
    Datatable with rows meeting the specified criteria
  2. Type: Table
    Filtered Out
    Datatable with rows not meeting the specified criteria

Extension

The Row Splitter node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    05 Join and Concatenate
    Join Concatenate
    Exercise for joining and concatenating data. Combine data tables side-by-side using the j…
    kellej6 > IT4015 Applied Business Intelligence > Lab 3 > L3-WA_Fn-UseC_-Telco-Customer-Churn > Exercises > 07 Join and Concatenate
  2. Go to item
    [Community Nodes] CN-155 Scale Demographic Node
    The Scale Demographic node changes the Willingness To Pay (WTP) values of all Customers w…
    scientificstrategy > Public > Community Nodes > CN-155 Scale Demographic Node v05
  3. Go to item
    Add Column Headers after Reading
    kathrin > Forum Questions > Add Column Headers after Reading
  4. Go to item
    compare_row_pairs
    lukass > Forum > compare_row_pairs
  5. Go to item
    Basketball
    lisaawidmeyer > Public > DDS Basketball
  6. Go to item
    Editing the tables for the model factory
    Model process Model process factory Enterprise
    This workflow is part of the model factory eco system. Please refer to our white paper fo…
    knime > Examples > 50_Applications > 26_Model_Process_Management > Metainfo > Edit_Tables_Locally
  7. Go to item
    Split_Table_at_First_Occurence_of_Value
    nemad > Public > Split_Table_at_First_Occurence_of_Value
  8. Go to item
    Rank each column by value ignoring blanks
    elsamuel > Public > Rank each column by value ignoring blanks
  9. Go to item
    Line_Plot
    kathrin > Forum Questions > Line_Plot
  10. Go to item
    Unify different time formats
    There has been no description set for this workflow's metadata.
    kathrin > Forum Questions > Convert Date&Time
  1. Go to item
  2. Go to item
  3. Go to item
  4. Go to item
  5. Go to item
  6. Go to item

KNIME
Open for Innovation

KNIME AG
Hardturmstrasse 66
8005 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Server
© 2022 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits