In Chapter 1, Catching Up with Tableau 2018, about data connection, you saw how to create joins between different Tables of the same dataset. With cross-database Joins, you can create joins between different tables from different connections of different types. It's a great way to add new dimensions to your analysis.
Note
You can't use all the different types of connections in a cross-database Join. A published Data Source, for example, can't be joined.
As an example, let's create a join between Sample-Superstore and another Excel File, Reimbursement
, containing the reimbursed orders.
Note
To reproduce the following example, you need to download the Reimbursement
Excel file available on the website, book.ladataviz.com, in theChapter 12section, or use this link: https://ladataviz.com/wp-content/uploads/2018/09/Reimbursement.xlsx.
Here's what the Reimbursement
table contains:
Here's how to create a cross-database Join between those two files:
- Open Tableau, and click on the saved...