This content has been marked as final.
Show 5 replies
-
1. Re: Custom SQL Joining multiple table
Alexander Mou Jun 29, 2015 9:39 PM (in response to Leo Kaplun)A left bracket is missing:
tbl3$] AS table3
On Mon, Jun 29, 2015 at 8:02 PM, Leo Kaplun <
-
2. Re: Custom SQL Joining multiple table
Leo Kaplun Jun 29, 2015 9:44 PM (in response to Alexander Mou)thanks but that was just sudo code, not actual code.
I've been going over this all day. I just dont think Tableau supports multiple joins on custom SQL on Excel data source.
I just wanted someone to confirm this.
-
3. Re: Custom SQL Joining multiple table
Alexander Mou Jun 29, 2015 10:09 PM (in response to Leo Kaplun)3 of 3 people found this helpfulTableau does support multiple joins. The syntax is a little peculiar though:
Select *
From ([Orders$] as A inner join [Returns$] as B on A.[Order ID]=B.[Order ID])
inner join [Users$] as C on A.[Region]=C.[Region]
Here is the resulting workbook
-
4. Re: Custom SQL Joining multiple table
Leo Kaplun Jun 29, 2015 10:22 PM (in response to Alexander Mou)thanks Ill have to look into it again
-
5. Re: Custom SQL Joining multiple table
Jonathan Kawakami Jun 13, 2017 8:38 AM (in response to Alexander Mou)This worked! Thanks!