2 Replies Latest reply on Sep 6, 2018 5:36 PM by VBUG

    How to pass more than one value in a parameter to be used in custom SQL

    VBUG

      I have seen an example for Oracle but wondering if there is a similar example for Sybase. It would be much better to simply to have this functionality in Tableau. Rather than trying to figure out syntax for different databases.

       

      select * from tablename where name in (
      select regexp_substr(<Parameters.Parameter1>,'[^,]+', 1, level) from dual
      connect by regexp_substr(<Parameters.Parameter1>, '[^,]+', 1, level) is not null)