Table Difference Finder

[hmfa]

@Mo_Gha Please try this WF.
TableDIFF.knwf (51.6 KB)

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:

data set comparison

How can we apply the following scenario: data_set_1 has a key column and several columns. data_set_2 has an identical structure of data_set_1. We want to what common keys among them. what different keys among them in two direction. data_set_1 - data_set_2 and data_set_2 - data_set_1. compare between each column in data_set_1 with its mirror in data_set_2.