1 Reply Latest reply on Jun 18, 2018 3:16 PM by Peter Fakan

    How do I union two fields of data that are the same data but not identical?

    Susan Christensen

      I am brand new to Tableau and Tableau Prep.

      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?