Chapter 3. All about Data – Joins, Blends, and Data Structures
Connecting Tableau to data often means more than connecting to a single table in a single data source. You may need to use Tableau to join multiple tables from a single data source. As of Tableau 10, you can also join tables from disparate data sources. Sometimes, you may need to merge data that does not share a common row-level key. In such cases, you will need to blend the data. Also, you may find instances where it is necessary to create multiple connections to a single data source in order to pivot the data in different ways. This may be required in order to discover answers to questions that are difficult or simply not possible to address with a single data structure.
In this chapter, we will discuss the following:
- Complex joins
- Data blending
- Data structures