forums

Use these forums to ask questions and discuss Tableau.

Table joins using calculated dimensions

Posted February 12th, 2008 by Bob Aronoff
in Data Sources and Performance

In a project I am joining two tables. The source tables are in an Excel file. When defining the join the only options I see are based on the original table fields. I am hoping to join based on the first three characters in a particular field. It is easy to create a calaculated dimension but these calculated fields are not available as a join option. Is there a way around this in Tableau?

Thank you

Add new comment

Comments

On February 12th, 2008 Bob Aronoff said:

It is humbling when one answers their own post. In case others have this issue here is the work around I found.

Create a new connection to the Excel file using multiple tables. Create a join that is close to what you wish to achieve. Select the button that allows you to specify a SQL query. It will display the SQL for the join you specified. Next modify the join to reflect the calculated intermeadiary dimension needed for your purposes.

This worked in my instance.

reply