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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
Alteryx Gallery is experiencing a problem in which system emails are not being sent out. As a result, if you are attempting to sign up for a new account, you may be unable to verify your email address. We are working to solve this as soon as possible and will remove this notice once resolved.
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