Reference Row Filter

This node allows rows to be filtered from the first table using the second table as reference. Depending on the dialog setting, the rows from the reference table are either included or excluded in the output table.
During the test for in-/exclusion the values of the selected columns of both tables are compared.

Options

Data column (in first input)

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

Reference column (in second input)

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

Include or exclude rows from the reference table

Includes or excludes all rows from the reference table in the resulting table from the first input.

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_Network_Traffic_ReportingKNIME Hub
• [01.CX] Combining Siloed Legacy Data with Running App's Back-End DatabaseKNIME Hub
• 00 Main MenuKNIME Hub
• 00 Main MenuKNIME Hub
• 00 Send Reporting_vMediumKNIME Hub
• Show all 1706 workflows

Links

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

  forum.knime.com/p/96640
• Deleting duplicates from filesby izaychik63 on 2020-02-27

  forum.knime.com/p/82853
• Compare data in 2 columnsby izaychik63 on 2019-10-29

  forum.knime.com/p/73515
• Concatenate Bug?by armingrudd on 2020-02-16

  forum.knime.com/p/81689
• Only update new filesby armingrudd on 2019-10-04

  forum.knime.com/p/71655
• Show all 24 links

Developers