This content has been marked as final.
Show 6 replies
-
1. Re: Custom SQL function in Tableau 9.3
Tom W Sep 8, 2016 4:32 AM (in response to Periyasamy S)You could put your code inside a stored procedure and connect to that.
-
2. Re: Custom SQL function in Tableau 9.3
Tharashasank Davuluru Sep 8, 2016 5:36 AM (in response to Periyasamy S)Hi,
Please create a store procedure and try to connect to that.
-
3. Re: Custom SQL function in Tableau 9.3
Periyasamy S Sep 15, 2016 5:38 AM (in response to Tom W)Hi Tom,
I tried it after creating a stored procedure. But while executing the stored procedure, I am again facing the same problem with 'EXEC' keyword.
Can you plz help me on this.?
Thanks.!
-
4. Re: Custom SQL function in Tableau 9.3
Periyasamy S Sep 15, 2016 5:38 AM (in response to Tharashasank Davuluru)Again facing the error as
[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'EXECUTE'.
[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near ')'.
Please help me on this.
-
5. Re: Custom SQL function in Tableau 9.3
Tom W Sep 15, 2016 9:33 AM (in response to Periyasamy S)You will need to provide the definition of the stored procedure.
-
6. Re: Custom SQL function in Tableau 9.3
Periyasamy S Sep 16, 2016 2:10 AM (in response to Tom W)Thanks Tom.! I have created a user defined function and called it from tableau and it worked.!