Join if x/x fields match

[donnellyaj]

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 Birth	First Name	Last Name	City
01/01/85	John	Doe	Springfield

Table 2

Date of Birth	First Name	Last Name	City
01/01/85	Jon	Doe	Springfeild

[ChrisTX]

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