Reference Row Splitter

This node allows rows to be split from the first table using the second table as reference. Rows which are available in both the input table and the reference table will be written into the table of the first output port. All others in the second one.

Options

Data column (in first input)

The column from the table to be split that should be used for comparison.

Reference column (in second input)

The column from the filter table that should be used for comparison.

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

• !Modern UI_ABC-XYX-RFM AutoML SuperstoreKNIME Hub
• (3D) Fragment library design workflow v1.1KNIME Hub
• 0_install_AI_extensionsKNIME Hub
• 00_xplan sf dbconv-insert via xport-AccountKNIME Hub
• 00_売上集計レポート・アプリKNIME Hub
• Show all 337 workflows

Links

• How to efficiently split a table based on another table?by izaychik63 on 2020-07-11

  forum.knime.com/p/96640
• To Find unmatched rows from 2 different tablesby tommy on 2020-06-25

  forum.knime.com/p/95258
• Searching for notes to create a reverse filter of customer numbersby armingrudd on 2019-05-02

  forum.knime.com/p/59801

Developers