3 Replies Latest reply on Jul 7, 2016 8:07 AM by Dave Rawlings

    Manual Field in Custom SQL

    Todd Moses

      I am trying to union two tables together to get my data source for the workbook. 

       

      I want the custom SQL data source in my workbook to be:

       

      SELECT "TABLE1", [PERIOD_DATE]

      FROM MYTABLE

       

      UNION ALL SELECT "TABLE2", [PERIOD_DATE]

      FROM MYTABLE

       

      How do I create the "TABLE1" & "TABLE2" in the tableau custom SQL?  I keep getting a error connecting to the data source.

       

      Thank you