Icon

Table Compare

Add a new row in the compare input and it works as expected Delete row 3 from reference input and everything slips Delete row 3 from compare input and everything slips Add a new row in the reference input and it works as expected Code is the key for the data. Ideally the Table Difference Finder node could use ROWID as the key between the tables. My issue here would be resolevd by adding the ROWID node and promoting Code toROWID. Node 1Node 2Node 3Node 4Node 5Node 6Node 7Node 8Node 9Node 10Node 11Node 12Node 13Node 15Node 16Node 17Node 18Node 19Node 20Node 22Node 23Node 24Node 25Node 26Node 27Node 28Node 29Node 30Node 31Node 32Node 33Node 34Node 35Node 36Node 37Node 38 Table Creator Table Creator RowID RowID Table DifferenceFinder Sorter Sorter Table Creator RowID Sorter Table Creator RowID Sorter Row Filter RowID Table Creator Table Creator Row Filter Sorter Sorter RowID Sorter Sorter RowID Table Creator Table DifferenceFinder Table Creator RowID Joiner (Labs) Column Splitter Table DifferenceFinder Column Rename Column Rename Table DifferenceFinder Joiner (Labs) Column Splitter Add a new row in the compare input and it works as expected Delete row 3 from reference input and everything slips Delete row 3 from compare input and everything slips Add a new row in the reference input and it works as expected Code is the key for the data. Ideally the Table Difference Finder node could use ROWID as the key between the tables. My issue here would be resolevd by adding the ROWID node and promoting Code toROWID. Node 1Node 2Node 3Node 4Node 5Node 6Node 7Node 8Node 9Node 10Node 11Node 12Node 13Node 15Node 16Node 17Node 18Node 19Node 20Node 22Node 23Node 24Node 25Node 26Node 27Node 28Node 29Node 30Node 31Node 32Node 33Node 34Node 35Node 36Node 37Node 38 Table Creator Table Creator RowID RowID Table DifferenceFinder Sorter Sorter Table Creator RowID Sorter Table Creator RowID Sorter Row Filter RowID Table Creator Table Creator Row Filter Sorter Sorter RowID Sorter Sorter RowID Table Creator Table DifferenceFinder Table Creator RowID Joiner (Labs) Column Splitter Table DifferenceFinder Column Rename Column Rename Table DifferenceFinder Joiner (Labs) Column Splitter

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: ipl
Created at: 2021-01-11
On NodePit since: 2022-02-06
Last update: 2024-04-27
Created with KNIME version: v4.4.0 nightly

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

Try NodePit Runner!