Cross Database Joins - Tableau in Two Minutes
In this video, we walk through cross database joins. These are a way of creating joins or unions on mulitple data sources at the same time. We'll join two different Excel files (although you can do the same with two different databases). You can use the smae join technique for a database and an Excel file, a database and a CSV, an Excel file and a CSV, etc.
We cover:
How to set up your first connection.
How to add a second connection.
How to look at the tables in each connection.
How to define the join.
How to identify which columns are from which source.