KNOWLEDGE BASE

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

Issue

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

Environment

Tableau Desktop 9.0 and later versions

Resolution

Create two joins and define the relationship separately.

Cause

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.
Did this article resolve the issue?