Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Community v19.6

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More

WHERE IN Statement in Custom Filter


Can you use a WHERE IN statement in a custom filter?


Where [zip] in ("12345", "98765", "65432")


Or, is there another statement in the custom filter to accomplish the above without joining multiple filters?

Alteryx Certified Partner

The custom filter syntax doesn't require the "where". This is the expression:


[ZIP] in ("12345","98765","65432") 


Thanks.  I wonder if there is a list of common custom filter syntaxes?  Or, is it just SQL with Select and Where?

Alteryx Certified Partner

Tools where you can enter custom expressions (ex: Filter, Formula, Multi-Field Formula, Multi-Row Formula) also feature a list of functions that can be used for reference or double-clicked to insert. The expression used in this case is found in the "Operators" section.