I have a question about preparing two data sources.
I have two tables of data with a common field of data. Although the data is the same (name and date of birth) it is not entered identically (ex: John Smith 01/01/2000 vs Smith, John 01/01/2000). How can I prep my data so these two fields can a common identifier between the tables? Can I use a fuzzy match algorithm? Other?