1 Reply Latest reply on Aug 15, 2018 7:44 AM by Jim Dehner

    Parameters transforms string data to unicode string data

    Jisu Jeong

      I'm using tableau with Oracle SQL.

       

      I've tried to use date as a parameter but there's a problem.

       

      Originally, the type of date is string( ex. '20180727'). But when I put the date as parameter, SQL queried the date as a unicode string type like N'20180727'.

      (<1.parameter> in Tableau  ---> select 20180727 ------> Query in SQL is N'20180727') 

       

      If the type of date changes, it takes much more time for query since I'm using index with string type data.

       

      So I really hope to find the way that using parameter with no change of data type.

      (<1.parameter> in Tableau  ---> select 20180727 ------> Query in SQL is '20180727') 

       

      Thanks for reading.