3 Replies Latest reply on Jul 4, 2018 2:35 PM by Deepak Rai

    Union Custom SQL

    Daniel Jung

      Hi,

       

      I'm trying to figure out a good solution for my problem. What I have is several different databases that have similar but different schemas from each other. What I would like to do is write custom SQL in Tableau for all the databases and then UNION the result of those custom SQL statements. I don't believe this is possible through Tableau alone but it is something I would like to do.

       

      One possible workaround (which are not ideal) I could think of to do this is to create separate data sources for each DB and create a workbook that connects to each of these different data sources.

       

      Any ideas?