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.
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
e. Open the Excel created by your internet browserIn Excel, copy the identifiers to be used in the next workbook. In this example, copy the Campus ID’s.
Go to the second workbook
Paste the identifiers into the appropriate filter of the second workbook. In this example, paste the Campus ID’s into the filter of the Student Demographics IDE.
The pasted identifiers will appear as a list below the filter box.
Tip: To remove an identifier, hover and click the X. To remove all and start again, select Clear List.
Select any other filters necessary for generating results
Export the Crosstab data into Excel
Need More Information or Help?
If you have questions about this Tableau document, please contact Steven Tan, Office of Data Management and Analytics Services (ODMAS)