Cross Database Joins
komalgulzarofficial
Joining functionality has been greatly enhanced with the advent of Tableau 10. The capability now exists to joinmultiple data sources together within the Data Source window.1. In Tableau, on the File menu click New to open a new session. Click the Go to Start Page icon.2. Click Excel to connect to an Excel file.3. Select Enrollment Fact.This will open the file and will look the same as it did when opening any Excel file. You have the sameoptions available whether a single or multiple tabs exist.4. In order to connect to a second file, click on the Add link next to the Connections header.5. Indicate the file you’d like to open selecting from the connection options available. Select the Excel file Class Dimension.6. Notice that Tableau will automatically set the join if there is only one tab.7. When complete, your connections should be ready.