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
SOLVED

Adding Multiple criteria to a Basic Filter

Highlighted
Meteor

Hi Kane, 

 

What would be the formula if I want to filter out the rows that "contain" different letters or symbols?

For example, I want to filter out all those fields that have the letter "F", the "-" and the "_".... 

 

Thanks! 

Atom

Hi Benjamin, your join tool idea is pretty flexible! This way, people can easily update the source file if there are any additional filters.

 

Would this work if the text I want to filter is only the first two letters?

An example is:

Filter criteria: those beginning with DM and PO. 

Data to be filtered:

DMUHG

BETSY

HIGHK

POLOP

 

Thank you!

Labels