I am passing workflow constants in my SQL query input tool like below:
I want to be able to query multiple items - e.g Strategy in ('Forwards', 'Down200')
When I enter in my workflow constants like this with single quotes, the query errors because the quotes - it looks like Alteryx adds a single quote around the whole input string - and SQL cannot interpret this
Log:
If I submit my inputs without the single quote, the query completes, but no records are returned:
Log:
The query works if I only pass one value - e.g. Down200 with no quotes.
I want to be able to pass one value as a constant - e.g. ('Down200') or two values ('Down200', 'Forwards')
How do I structure my SQL query input tool and/or Workflow inputs in order to query multiple items in an IN condition?
Thanks!
