KNOWLEDGE BASE

Some Join Operators Unavailable in Excel or Text Data Connections


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

Issue

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

Environment

  • Tableau Desktop
  • Microsoft Excel
  • Text files

Resolution

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.


 

Cause

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?