community
cancel
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
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?

Highlighted
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