TableDIFF

Compare two Tables (extended).

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: