Multiple Interface Tools

Avi6999

Hi Alteryx Community,
I'm working on a dynamic workflow where I use interface tools to pass user inputs into a SQL WHERE clause. I have 4 parameters, 3 are Text Boxes and 1 is a List Box. The dynamic WHERE clause works perfectly when I use a Text Box for the fourth parameter. However, when I switch to a List Box for the fourth parameter, the results are not being pulled even though the formatting seems correct.

apathetichell

@pstrasser is correct... 1) for a listbox your action tool should be configured in list mode. and use " "," " as your separators. 

2) when you are configuring to replace something in your action tool --- use replace a specific string --- and include the quotes --- you are replacing a full list --- not just a value. I use this often with IN.

as an alternative you can configure your list tool with \n as a delimiter --- split it to  different text input. use text to columns to split to rows with \n -- and then use summarize to build. I would do this to capture errors.