Last Modified Date: 08 Jul 2022
- Tableau Desktop
- If in 8.2 or later, but earlier than 2019.1 (see note in Additional Information below), connect to the data using a legacy connection. If in 8.1 or earlier, connect as usual.
- Write custom SQL for a UNION of a LEFT and RIGHT join.
Option 2Mirror the data to a database that supports a Full Outer join, such as MS SQL.
CauseWhen connecting to data on a Microsoft Access database, the outer join is not available due to limitations in the Microsoft Access database.
Additional InformationJoin tables and queries in Microsoft Office Support.
Note Starting in Tableau 2019.1, you can no longer create a new Legacy Excel or Text connection. Existing workbooks created with these legacy connections will continue to work until 2019.2, when all support for legacy connections will be removed. See the Legacy Connection Alternatives document in Tableau Community for alternatives to using the legacy connection.
Discuss this article...
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials