Cross – database joins
Tableau 10 introduces the ability to join (at a row level) across multiple different data connections. These joins are referred to as cross-database joins or cross-data connection joins. For example, you can join SQL Server tables with text files or Excel files or tables in one database with tables in another. This opens all kinds of possibilities for supplementing your data or analyzing data from disparate sources.
With Tableau 10, you can add additional data sources to a connection and join tables from the different sources. Consider the hospital data mentioned previously. It would not be uncommon for billing data to be present in a system different from the patient care data. Let's say you had a file for patient ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access