Loading

How to Make a Full Outer Join in Tableau Desktop When Some Databases Do Not Support Outer Joins

Julkaisupäivä: Apr 13, 2024
Tehtävä
How to make a full outer join in Tableau Desktop when your database does not support outer joins. 

Note: If a database that does not support full outer joins is added to the connection, the full outer join will not work in Tableau Desktop.

For example, when connecting to MySQL, Full Outer joins are not available.
User-added image

 

Vaiheet
As a workaround, please consider creating Custom SQL to Union left join and right join.

For example, the CustomSQL could be written as follows to make a full outer join of Table A and Table B possible. 
select A.No, A.Column1, A.Column2, B.Column3
from A
     left outer join B
     on A.No = B.No
  
UNION
  
select B.No, A.Column1, A.Column2, B.Column3
from A
     right outer join B
     on A.No = B.No

 
Knowledge-artikkelin numero

001469781

 
Ladataan
Salesforce Help | Article