Comparison of two excel tables based in one column

Hi all, i am new and need some help.

I have two excel files, "old.xls' and "new.xls". Both files have different row content but same column structure. I need compare the files based on a column called: "ID" and generate a resulting file with the same estructure of columns but only with the new rows, not existing from old.xls, I mean, need to create a resulting file with the "delta" of new.xls and old.xls.

Anyone can please help me?


Hi Changoman,

the reference row spliter can split based on the values of a second data table.

If you split table old on the values of table new the second port has the values which are old but not in new.

Cheers, Iris