Icon

TableDIFF

This workflow extends Ipazin work to compare 2 tables with same structure meaning they have same number of columns and matching columns have same names and types. Comparison is done in a loop using Column Comparator node. In each loop iteration two columns are compared and and additional column with values TRUE or FALSE is created.
Aditionaly writes excel file with separated sheets for delete, inserted, updated, unchanged records

Forum link:
https://forum.knime.com/t/data-set-comparison/18507
https://forum.knime.com/t/compare-content-of-multiple-columns-in-pairs-of-two/15950

Extended Compare two TablesThis workflow extends Ipazin work to compares 2 tables with same structure meaning they have same number ofcolumns and matching columns have same names and types. Comparison is done in a loop using ColumnComparator node. In each loop iteration two columns are compared and and additional column with values TRUE orFALSE is created.Aditionaly writes excel file with separated sheets for delete, inserted, updated, unchanged records Forum link: https://forum.knime.com/t/data-set-comparison/18507https://forum.knime.com/t/compare-content-of-multiple-columns-in-pairs-of-two/15950 REFERENCETABLENEWTABLESEPARATENEW FROMOLDCOLLECTIONKEYCOLLECTIONKEYINSERTEDONESINSERTEDONESDELETEDONESDELETEDONESSAMEONESSAMEKEY_IDSAMEONESDIFFERENTONESDIFFERENTONES Table Creator Table Creator Joiner Create CollectionColumn Create CollectionColumn Excel Writer Column Filter Column Filter Excel Writer Excel Writer Joiner Column Filter Excel Writer CHANGES Extended Compare two TablesThis workflow extends Ipazin work to compares 2 tables with same structure meaning they have same number ofcolumns and matching columns have same names and types. Comparison is done in a loop using ColumnComparator node. In each loop iteration two columns are compared and and additional column with values TRUE orFALSE is created.Aditionaly writes excel file with separated sheets for delete, inserted, updated, unchanged records Forum link: https://forum.knime.com/t/data-set-comparison/18507https://forum.knime.com/t/compare-content-of-multiple-columns-in-pairs-of-two/15950 REFERENCETABLENEWTABLESEPARATENEW FROMOLDCOLLECTIONKEYCOLLECTIONKEYINSERTEDONESINSERTEDONESDELETEDONESDELETEDONESSAMEONESSAMEKEY_IDSAMEONESDIFFERENTONESDIFFERENTONES Table Creator Table Creator Joiner Create CollectionColumn Create CollectionColumn Excel Writer Column Filter Column Filter Excel Writer Excel Writer Joiner Column Filter Excel Writer CHANGES

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: E314382
Created at: 2022-06-03
On NodePit since: 2022-06-04
Last update: 2024-04-27
Created with KNIME version: v4.5.2

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

Try NodePit Runner!