community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

WHERE IN Statement in Custom Filter

Asteroid

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") 

Asteroid

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.

 

FilterFunctions.png

 

 

 

 

Labels