Error "Tableau Data Engine Error: 4: multiple join comparisons on the same column are not supported"
Published: 16 Sep 2015 Last Modified Date: 08 Aug 2016
When performing an inner join on two fields in the right table, with the same field value, the following error might occur:
Tableau Data Engine Error: 4: multiple join comparisons on the same column are not supported
Tableau Desktop 9.0 and later versions
Create two joins and define the relationship separately.
Earlier versions of Tableau Desktop allowed multiple join comparisons on the same column, however the results were often inconsistent. Starting with Tableau Desktop 9.0, this type of join is disallowed.
Thank you for providing your feedback on the effectiveness of the article.