Can't Get List From Values to Work, Not Even Knowledge Base Example Works (for me)

[hellyars]

I am trying to use a List Box to update a Filter tool.  I found this example in the knowledge Base.   I specifically want to copy the #2 example.   

I set things up exactly the same and it does not work.  There are no errors.  The filter simply does not let anything pass.  So, I checked to see the example I downloaded (from the knowledge base entry link below).  It also does not work.  Select as many customer segments as you want, nothing passes thru the filter.

I am running 2020.3 (because 2020.4 has an XML parse issue).  

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Dynamically-Create-List-Box-Values-... 

[AngelosPachis]

Hi @hellyars ,

I think this configuration of the list box tool won't work well with a filter tool.

To filter for each customer segment, what you should do is use an In function, so check if any value contained in the Customer Segment field is equal to any of the values in the brackets.

If I had to translate that to an If statement, then that would be 

If [Customer Segment]="test" OR [Customer Segment]="test1" ......

Then, you can configure the list box tool to form the string within the brackets, which will be a concatenated version of the checked boxes in the apps interface. So if I check Consumer and Home Office, the string that will be formed is

"Consumer","Home Office"

and that string will replace the values in the filter tool (that is done in the filter tool)

Give this workflow a try, I think it will work for you. 

Cheers,

Angelos

[hellyars]

Can you repackage.  The input file appears to be missing.

[AngelosPachis]

There you go @hellyars 

[hellyars]

@AngelosPachis   My version does not like yxwz.   I am on 2020.3.  I had to downgrade because 2020.4 has a few issues with the XML parse tool that broke a bunch of workflows.

[AngelosPachis]

Hi @hellyars ,

I don't think that this is the case, because you also sent me a .yxwz file, within that .yxzp file.

Have you tried opening it in designer and it didn't work?