KNOWLEDGE BASE

Unable to Join Tables on Calculated Field


Published: 17 Nov 2016
Last Modified Date: 26 Aug 2019

Issue

You are unable to join tables at a calculated field level. 

Environment

Tableau Desktop

Resolution

Option 1

Starting with Tableau Desktop 10.2, the ability to customize joins using calculations was added to the product to resolve format mismatches between fields. For more information, see  Join Your Data.

Option 2

For earlier Tableau Desktop versions, the ability to join on calculated fields was not built into Tableau Desktop. When tables or data sources are joined, a query reflecting the join is sent to the data source. Calculated Fields exist at the workbook level, not the data source level. 
Try one of the following workarounds: 
  1. Use Data blending. For details, see Blend Your Data.
  2. Use Custom SQL. For more information, see Connect to a Custom SQL Query.
Did this article resolve the issue?