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

Multiple filter expression builder

Atom

Hi

 

is there any expression builder within Alteryx where i can build below contains multiple filter ?

 

Contains([Account Number],"233") OR Contains([Account Number],"246")

 

just like above i need to make around 150-200 contains.

 

is it possible ?

Alteryx
Alteryx

If I understand your questions correctly, you would like to apply that condition to multiple columns.  In that case, you can use the Multi-Field Formula tool.  Your formula will look something like this:

 

Contains([_CurrentField_],"233") OR Contains([_CurrentField_],"246")

 

Please let me know if this helps.

Hasan

Yes, you can do this.

 

Start by using Alteryx to build the expression, you can then feed this into a batch macro.

 

I've packaged up an example.

 

Quasar

Hi @Dushyant

 

A Find a Replace tool, followed by a Filter tool, should do the job.

 

Capture.PNG

Atom

Thanks Hasan. 

 

No i dont want on multi colms but the data is in only 1 column and i just need to build this expression rather than using some forumlas in excel to build this expression.

 

Thanks

Atom

Thanks but i am getting version error since i am using old version to build this.

 

unfortunately i cannot use a newer version due to license agreement from my organisation.

 

i guess i will go ahead with building expression using excel formula.

 

thanks

Quasar

+1 to @jasperlch's solution. That's how I might tackle it. Try it out if you haven't already.

Labels