Cross database joins

Tableau gives you the ability to join data across data connections. This means that you can join tables of data from completely different databases and file formats. For example, you could join a table in SQL Server with a union of text files and then join them to a Google Sheets document.

You'll recall that the concept of joins and the specifics of cross database joins were introduced in Chapter 2, Working with Data in Tableau. While cross database joins are quite useful in bringing together disparate data sources (data contained in different systems and formats), they can be used to solve other data issues too, such as reshaping data to make it easier to meet your objectives in Tableau.

You can work through the following example in the Chapter 9 workbook, but the server database data source is simulated with a text file (Patient Visits.txt).
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.191.189.23