Difference Finder for 2 tables

Hi There!
I need to compare two tables - one I take from the database, the other from excel. I reconcile 3 fields: ID, name, description. As a result, I want to get a report that the tables are identical or the opposite - a list of rows that do not match.

I loaded both tables, prepared the data and brought them to the same form in both tables.
After cleaning the data in the tables was a different number of rows - in the table from the database - 986, and in the table of excel - 935 (! This is important, because in a similar test with another database, where the number of rows matched in both tables check was successful!)

A few rows the check was successful when comparing the name and description.


However, at some point the logic was broken (probably mine) and the node started comparing rows with different IDs. That is, it literally says that ID 613 is not equal to ID 614 and, respectively, the name and description of the string with ID 613 is not equal to the name and description of the string with ID 614. And so on to the end of the entire table.

I don’t understand the reason and can’t finish my check

Ошибки fx_function VS 21.0.0 DIFF 1.knwf (38.3 KB)

p.s. I previously reviewed all the topics and all the proposed solutions, but did not find anything suitable for me, which would help to solve this difficulty

1 Like

Hi @DanShcherbakov

Welcome to the KNIME Community!

Could you please re-upload your workflow with some of the data pre-loaded? Right now the nodes are in yellow which means it has to read the data again. Since you are connecting to a DB and a file on your local machine, we cannot see the WF in action and help you out effectively.

image

Please run the workflow to include the input, and then export it again and uncheck the option to reset it before export.

1 Like

Hi @DanShcherbakov

Just an idea. There may be an new-line “character” or something similar in your Excel file. Go to the first row where the rowID’s doesn’t match, and see if there is anything “strange” in your Excel cell…

gr. Hans

Did you try the Table Difference Finder already?

It is in his workflow :wink:

image

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.