Some Join Operators Unavailable in Excel or Text Data Connections

Published: 20 Jun 2014
Last Modified Date: 24 Apr 2017


When you try to create joins with Microsoft Excel or text data sources in Tableau Desktop 8.2, the only available operator is the equal sign.

User-added image


  • Tableau Desktop
  • Microsoft Excel
  • Text files


If you are using Tableau Desktop on Windows, use the following workaround:
  • In Tableau Desktop, navigate to your Excel or text file data, click the drop-down arrow on Open, and then select Open with Legacy Connection.



Tableau Desktop 8.2 does not use the Microsoft JET data engine by default. The JET engine made the majority of the join operators possible.
Did this article resolve the issue?