Loading

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

Data pubblicazione: Apr 13, 2024
Operazione
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

 

Fasi
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

 
Numero articolo Knowledge

001469781

 
Caricamento
Salesforce Help | Article