Using 2 Tableau Workbooks to Pull Data
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.
How to Use Multiple Tableau Workbooks to Achieve Results
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.
- 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.