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

Alteryx designer Discussions

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

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.

 

Bolide

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