1 Reply Latest reply on Jan 14, 2013 1:12 PM by Tracy Rodgers

    Full outer join on three tabs in Excel database

    Abhay singh

      Hi,

       

      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

       

      Regards,

      Abhay