Filtering by more than one term

[BillyL14]

Hi

I am trying to filter by more than one term. I tried

[Code] = "AAA" and "BBB" and "CCC"

but it doesn't work.

What is the correct way to do this?

Thanks

[Emil_Kos · Accepted solution]

Hi @BillyL14 we meet again,

Please look at this topic:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/WHERE-IN-Statement-in-Custom-Filter/td...

I cannot test it now but I think the answer would be 

[Code] in ("AAA","BBB","CCC") 

[jdunkerley79 · Accepted solution]

Probably the simplest expression is:

[Code] in ("AAA","BBB","CCC")

[purnimat]

Hi @BillyL14 ,

Slight modification: [Code] = "AAA" and [Code] = "BBB" and [Code] = "CCC".

Try this and let me know if this helps.