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

Manual Field in Custom SQL

Todd Moses Jul 7, 2016 6:51 AM

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

1. Re: Manual Field in Custom SQL

Dave Rawlings Jul 7, 2016 7:43 AM (in response to Todd Moses)

Does this work?

SELECT "TABLE1" as [Table], [PERIOD_DATE]
FROM MYTABLE

UNION ALL

SELECT "TABLE2" as [Table], [PERIOD_DATE]
FROM MYTABLE
1 of 1 people found this helpful
Like Show 1 Likes(1)

Actions
2. Re: Manual Field in Custom SQL

Todd Moses Jul 7, 2016 8:01 AM (in response to Dave Rawlings)

What seems to work is:

SELECT 'TABLE1' AS "TABLE", [PERIOD_DATE]
FROM MYTABLE
Like Show 1 Likes(1)

Actions
3. Re: Manual Field in Custom SQL

Dave Rawlings Jul 7, 2016 8:07 AM (in response to Todd Moses)

That could be the correct syntax, I've spent far too long working with Access
Like Show 0 Likes(0)

Actions

Tableau Community