See if a combination of 3 columns is the same in second file

KNIME Analytics Platform
1

Hi all,

I need to see if 3 columns in 1 file are the same as in a different file. The 3 columns are first name, last name and birthdate.

But I don't know how I should tackle this. Groupby first name for both files and than a reference rowfilter?

Any ideas?

Thanks!

2

Hi Marc,

if you are looking for identical rows you can use the joiner node to join the two tables based on the three columns that should match. If you use an inner join the result table will contain only tripples that exist in both tables.

If you also want to search for similar entries you could use the Indexing and Searching extension which comes with a fuzzy addess matching example.

Bye,

Tobias