Icon

Row by row comparison

Process rows in one table in groups so they can be compared with a second table.

Output 3 tables which are:
Matching Rows
Rows only in Table1
Rows only in Table2

Table 1Table 2Process each group of valuesget column value as variableCreate rowid for this groupingGet rows for current groupCreate rowid for this groupingjoin onROWIDTop=MatchMid=In table 1 onlyBot = in table 2 onlyTop=MatchMid=In table 1 onlyBot = in table 2 onlyBottom = only in table 2(so they weren't processed by the loop)Table 2 onlyview outputsTable Creator Table Creator Group Loop Start Table Rowto Variable RowID Row Filter RowID Joiner Loop End Joiner Concatenate Excel Writer Column Filter Table 1Table 2Process each group of valuesget column value as variableCreate rowid for this groupingGet rows for current groupCreate rowid for this groupingjoin onROWIDTop=MatchMid=In table 1 onlyBot = in table 2 onlyTop=MatchMid=In table 1 onlyBot = in table 2 onlyBottom = only in table 2(so they weren't processed by the loop)Table 2 onlyview outputsTable Creator Table Creator Group Loop Start Table Rowto Variable RowID Row Filter RowID Joiner Loop End Joiner Concatenate Excel Writer Column Filter

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: BATEB031
Created at: 2023-08-11
On NodePit since: 2023-08-11
Last update: 2024-04-27
Created with KNIME version: v4.7.4

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

Try NodePit Runner!