In this example, a SQL query has a parameter:
SELECT * FROM table1
WHERE state IN @state
The string value provided to the parameter must be wrapped in quotes:
To pass multiple, delimited values, you must insert a break character (!) so InfoBurst will pass the quotes with the query:
When I use this method to pass multiple parameter to the query and burst the result, I get multiple outputs created. How do I get the result in one sungle spreadsheet for both the parameter values? I suspect it has to be the Multipass option checkbox but then it is grayed out for me to change it as well.