Extended Compare two Tables This workflow uses Ipazin work to compares 2 tables that have one KEY_ID field and same structure meaning they have same number of columns and matching columns have same names and types. Identifies old key records, new key ones and unchanged key ones. For changed fields, the comparison is done in a loop using Column Comparator node. In each loop iteration, two columns are compared and one additional column with values TRUE or FALSE is created. Aditionaly writes one excel file with separated sheets for deleted, inserted, updated and unchanged records Forum link:
Used extensions & nodes
Created with KNIME Analytics Platform version 4.6.0
Loading ad hoc executions
By using or downloading the workflow, you agree to our terms and conditions.
Discussions are currently not available, please try again later.