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. You can also join tables from disparate data sources or union data with similar metadata structure. 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 when 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 with a single data structure.
In this chapter, we will discuss the following topics:
- Introduction to joins
- Introduction to complex joins
- Introduction to join calculations...