Using fuzzy match to bring in unique identity numbers from different source

[pmckenn]

I have two large data sets each with a list of client information with a different set unique identifiers for each file. Some of the client names aren't exact matches which is where I think the fuzzy matching tool could come in. I would like to match the data together so I can eventually move the UEN's from one file to the other.

New to the fuzzy matching tool but I understand the basics on creating matches just not sure what I should do after to move the UEN's.

I made up some data here so you know what I mean to do. This could save me countless hours thanks!!

[JordanB · Accepted solution]

Hi @pmckenn

Take a look at this sample workflow which shows how to combine results back to the raw data. 

Once you have combined back in the raw data you can use a select tool to turn off any duplicate fields, as you should have the correct UEN number on the right row. 

Let me know if you have any other questions. 

Jordan Barker

Solutions Consultant