Join if x/x fields match

Question

I'm looking to do a conditional join if x/x (e.g., 2/4) fields match.

In the example below these two rows would join because two of the four fields (DOB and last name) match.

Table 1

Date of BirthFirst NameLast NameCity01/01/85JohnDoeSpringfield

Table 2

Date of BirthFirst NameLast NameCity01/01/85JonDoeSpringfeild

ChrisTX · Answer

You could try a waterfall approach.  First try to Join on DOB and Last Name, then the records that don't match willl go through the "waterfall" to another Join tool.  Repeat with a 3rd Join tool if needed.

Here's a sample workflow that uses the "try multiple match criteria" / waterfall approach, using a Fuzzy Match:

Chris