Using 2 Tableau Workbooks to Pull Data
How to Use Multiple Tableau Workbooks to Achieve Results
Users of UW-Madison’s Institutional Tableau workbooks may need to utilize more than 1 workbook to achieve all the desired information. This KB article explains how.
There may be times when users need data from multiple Tableau workbooks to achieve complete results. This can be done by generating a list of identifiers from one workbook and pasting them into the filter of another workbook.
For example, say you need to know the average age of students who received a BS in Botany in the Summer of 2018. The Student Academic Plans IDE can provide this list of students but does not provide their ages. On the other hand, the Student Demographics IDE provides student age data, but you first need to know which students to search on. Used together, these 2 workbooks can give you the information you need.
To use 2 workbooks collaboratively, follow these instructions:
- Generate a list of results from a workbook. In this example, use the Student Academic Plans IDE to pull a list of students that received a BS in Botany in the Summer of 2018.
- Follow these steps to export the Crosstab data into Excel. Refer to the KB Article on Exporting Data into Excel for more detailed instructions.
- a. Click on the chart to activate it
- b. Click Download
- c. Click Crosstab
- d. Click Download again
- e. Open the Excel created by your internet browser
Need More Information or Help?If you have questions about this Tableau document, please contact Melissa Chan, Office of Data Management and Analytics Services (ODMAS) at firstname.lastname@example.org.