KNOWLEDGE BASE

Some Join Operators Unavailable in Excel or Text Data Connections


Published: 20 Jun 2014
Last Modified Date: 03 Oct 2017

Issue

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


User-added image

Environment

  • Tableau Desktop
  • Windows
  • Microsoft Excel
  • Text files

Resolution

In Tableau Desktop, select Data > New Data Source.
Navigate to your Excel or text file, click the drop-down arrow on Open, and select Open with Legacy Connection.
Screenshot of the Open with Legacy Connection option
 

Cause

The current Tableau Excel connector only permits the "=" join operator. To use other operators, you must use the legacy JET engine based connection.
Did this article resolve the issue?