6 Replies Latest reply on Sep 16, 2016 2:10 AM by Periyasamy S

    Custom SQL function in Tableau 9.3

    Periyasamy S

      Hello !

       

      I have a requirement for using the cursor concept in the custom sql and I used declare statement in my SQL. But I am unable to execute the query in tableau and giving me the error message as "Incorrect syntax near the keyword 'DECLARE'." and "Incorrect syntax near ')'."

       

      On exploring the other community results for this error, I got to know that tableau accepts only simpler SQL and declaring any new variable is not possible. (This was some a post from 2 years back!)

       

      In tableau 9.3, is there any way or workaround for using DECLARE statements in the Custom SQL.

       

      Thanks.!