Cross-database Join

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:

1. Open Tableau, and click on the saved...