forums

Use these forums to ask questions and discuss Tableau.

Varying joins on separate sheets of the same workbook

Posted January 31st, 2008 by Bob Aronoff
in Data Sources and Performance

I am building a workbook connected to an excel file with multiple sheets. Each sheet is a separate table. The relation of the 'parent' to 'child' tables is one-to-many. For some queries this is what is desired. Some queries involve just the parent table but record counts naturally are 'inflated' due to the one-to-many joins. Is there a way to have different joins ( each on a separate sheet) to the same source excel file?

Add new comment

Comments

On February 2nd, 2008 Ross Bunker said:

Bob,
To do what you want, you simply connect to the excel file multiple times. First, connect to the excel file and set up the joins you want. Then, select Connect to Data again, choose the same excel file, but name the connection something different. In this one you can create different joins. Choose the names for your connections so that they are indicative of the detail that you are using in the data. You can do this as many times as you want to create different levels of detail.

:)ross

reply
On February 3rd, 2008 Bob Aronoff said:

Thank you. I was not specifically naming my Data Connections. Without that connection name the file name is used. Under that circumstance one can not connect to the file more than once. By naming the connection everything works as you described.

Bob

reply