Filtering using IN

Question

Hello,

Assuming I have a values columns with the letters of the alphabet I can do a filter [Values] IN ("A", "B") and this will give me all rows that are either A or B.

However, if I want this filter to be dynamic and I create a field, "Filter", where all values are a string, ("A", "B"), why doesn't the following filter work: [Values] IN [Filter]

I have attached a workflow with this example.

Thank you!

Filtering using IN.yxmd

binu_acs · Accepted Answer

@AlteryxTrev Alteryx will throw an error when you mention the filter like the above. the below post will help you to understand how you can achieve dynamic filtering

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Dynamic-Filter-Based-on-list-of-data-values/td-p/587965

Felipe_Ribeir0 · Accepted Answer

Hi @AlteryxTrev

It does not work because alteryx (besides the missing () in the IN that was causing an error) is understanding your filter as 1 unique string component ("A", "B")

To understand it better, try to test a dataset with Value = ("A", "B") and Filter = ("A", "B"). The filter will work. Make sense?

Take  look at the attached workflow to see this test and a simple alternative using the contains formula to achieve the desired result.