Hi
I’m pretty new with Knime. I’ve been searching for an hour on the examples and other topics without finding the answer. Probably due to my expertise in English (I’m French from Paris).
I have two tables, Table1 has 250K rows, Table2 40K.
both tables have the same number of columns and the same names.
I need to compare both tables and exclude from the Table1 the rows contained in TAble 2.
many thanks for your help
Esme
Dear Prashant,
thank you for you answer. I have tried this node but I must have configured it wrongly.
I have set the field on which the match should be done. In the Include in Ouput section, I said I want the Left Unmatched rows. I did not configured the other sections.
When I run the flow, the left output did not remove the matched rows. I still get the same numbers of rows.
I must have missed something.
Any clue?
thank you
Esme
Hi @Esme61
If you have only one field to check in both files, check out the Reference Row Splitter (or Filter).
gr. Hans
1 Like
Hi @Esme61 .
Have a look at
Br
1 Like
v1.0.1 is more logical to understand:
NOTE: I did it with one column, if you have same name of column and same number of column make sure you check below in configuration, else it will create more columns.
Hi hmfa,
thank you very much, this node is doing the job perfectly!
Esmé
2 Likes
1 Like