Name Match

[Rumanais]

Hello,

I have been trying to build a Workflow with two input files. 

1. one input file has First Name, Middle Name, Last Name in three different columns. The names are unique

2. the second input file has those same names in three different column but have multiple of them. This file also contain other information that I am wanting to append to file # 1 joining (using join tool)  by First Name and Last Name and if needed Middle name. 

But the result is returning  0 record, even though I know the name in file 1 does exist in File 2. 

I am attaching the 2 sample files, hoping someone could help!

[Qiu]

@Rumanais 

I tried with Join tool it returns some result.

[Rumanais]

Thank you Qiu! It certainly does work with these sample data set, however, for whatever reason, it's not working for the actual datasets. Where the second dataset is being pulled from TERADATA using SQL.

[caltang]

If it works for @Qiu - I think it can also be because your sample data is either 1-to-many / many-to-1, whereas the prod data that you have is many-to-many in nature. So you need to standardize it first on one end before you use Qiu's method. Something like this - try it and let us know:

[Gaurav_Dhama_]

Join tool is case sensitive, so if the case in your strings do not match, you will not get the results. Also check if there are any empty spaces in the string, even those will lead to no match.

I would suggest cleaning the data and making all the fields as either Upper case or lower case before matching.