Merging multiple data sources
Often, our data is stored in different formats or different files. In relational databases, if two different tables have a common field, we can join these two tables with this field and pull the data in one single query. Tableau supports joins within a single data source connection; however, to merge multiple data source connections, Tableau uses a concept called data blending. In this recipe, we will look at how to blend two different data sources.
Getting ready
Download the following Google Spreadsheet, which contains the U.S. population by states, after signing in:
Download it as a CSV on your local hard drive and name it USStatesPopulation.csv.
How to do it...
Once you have downloaded the CSV file, ...
Get Tableau: Creating Interactive Data Visualizations now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
