I have three data tabs in excel which I want to join using a Full outer join. Since I don't have a Full outer Join with excel database so I am using custom SQL query to achieve that. I am able to do a full outer join on two tabs using code which does an UNION on LEFT and RIGHT JOIN of two tables.This is working fine.
The approach I am following to do a full outer join of all three tabs is assigning an alias to the above mentioned code and doing a UNION of RIGHT and LEFT JOIN with the third table. But tableau is throwing an error "Syntax error in Join operation".
How do I use an alias in Tableau so that it does not throw any errors.
Thanks in Advance
Are you able to take a screenshot of the custom SQL box that is returning this error?