Cross-database join

In

Chapter 4, Connecting to Data and Simple Transformations, 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 connection types. It's a great way to add new dimensions to your analysis.

Tip

You can't use all the different types of connections in a cross-database join.

As an example, let's create a join betweenSample - Superstore and another Excel file, Reimbursement, which contains the reimbursed orders.

Tip

To reproduce the following example, you need to download the Reimbursement Excel file available at https://tableau2019.ladataviz.com, in the Chapter 11: Advanced Data Connections section, or use this link: https://ladataviz.com/wp-content/uploads/2018/09/Reimbursement.xlsx.

Here's what the Reimbursement table contains:

Let's see now how to create a cross-database join between those two files:

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