Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

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.