Need to pass multiple string values into query as a single parameter to filter in SQL before aggregating output to Tableau.
e.g.
select object, object_id
from table
where object in (<Parameters.Parameter 1>)
where Parameter 1 will have a string that contains a used defined list of values dependent on their needs
e.g1 Parameter 1 = 'Consumer','Corporate'
Hi, thanks. I'm using Impala query. The issue occurs when Tableau parameter adds in single quotes around the string ..... How do I specify that I don't want this to occur?
I tried an example of adding a single value to the parameter, but I added single (or double) quotes. The SQL failed to send as the SQL had a syntax error.
I added the following in the Parameter (including quotes) "Example1"
SQL resolved as:
select object, object_id
from table
where object in ('\"Example1"\')
...so when I add in multiple strings, it wiill mess up.
