Matching problem

KNIME Analytics Platform
1

Hi,

I have two tables:

1. For matching

first_name middle_name last_name
S.   Sigal
Sharon L. Gardner
T.   Bhatla
Yelena   Novik
Stephanie V. Blank
W.   Huang
Sandra V. Moore
Sarah Jeanne Leach

 

2. Main

first_name middle_name last_name
Samuel   Sigal
Sharon Leigh Gardner
Teena   Bhatla
Yelena   Novik
Stephanie V. Blank
William C Huang
Sandra V. Moore
Sarah J. Leach

How can I join both tables and create new table for match validation?

 

2

use the joiner node:

for joiner settings:

inner join and use add row, with last name on both sides.

for column settings: duplicate column handling: append suffix (depending if you want all the name varieties or not)