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

 

 

 

 

Asteroid

Thank you @CharlieS.  I would just like to add this syntax can be used in the Dynamic Select tool as well.  My use case involved finding the Fields I had deselected (with a Select tool) with the Field Info tool via Joining and then using the Summarize tool 'concat' function to come up with the syntax to paste into the Dynamic Select tool.

 

2019-10-02 10_56_00-Greenshot.png2019-10-02 10_56_29-Greenshot.png

Labels