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 Jun 18, 2018 3:12 PM

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?

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

Peter Fakan Jun 18, 2018 3:16 PM (in response to Susan Christensen)

Hi Susan,

I'm not 100% sure what you are looking for, but in Tableau Prep first prepare each table by splitting them into date and name dimensions, then bring them together should do the trick.

This will give you a common date and name dimensions and a single data source.

HTH

Peter
Like Show 0 Likes(0)

Actions

Tableau Community Forums

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

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

Actions

More Like This