Passing Value to Filter Through Listbox

[hemant86]

Hi Team,

I'm trying to pass value through listbox to a filter tool. Its working fine for me for the first 2 filter since I'm passing String value. But seem like values are not passed in the last filter (LOT). Looks like we need to apply some different logic for numbers passed to filter through list box. My requirement is user will select its combination and the available data as per the combination should be filtered. Attaching the workflow for your reference. Appreciate any help around this.

[Rags1982]

Hi @hemant86 

If you change the update tool for 'Select lot' to Update Value rather than the formula one, then tick the 'Replace a specific string' and remove everything apart from lotno, it will work ok. 

[caltang]

On List Boxes, Garett wrote an excellent piece here:

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/List-Box-amp-Filter-Tool/td-p/...

Attaching his Word doc here as well for your ease of reference.

[hemant86]

Thanks @Rags1982 for your response. I had tried that earlier but it gives me parse error. so tried to use formula. I downloaded the workflow which you amended. and I see parse error at Select Lot Filter. Things are fine when I'm passing string value but it fails in case of numbers

[danilang · Accepted solution]

Hi @hemant86 

When you use Update Value with Formula, you need to rebuild the entire string that you're replacing.   In Action(7) change the formula to 

"[Lot] In ("+[#1]+")"

resulting in [Lot] In ("1","3")

Your original would have resulted in just "1","3" which is not a valid filter string.  

Dan

[hemant86]

Hi @danilang Thanks for the solution. I had absolutely no idea about that. This works great.