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

Alteryx designer Discussions

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

Gather all 9 clues to complete the final Weekly Challenge on Dec 16!

Learn More
SOLVED

How to use filter to filter multiple words using wildcard function

Meteor

I want to use the wildcard to filter out data that has the following words: 

  • HODE% (ie. HODE12, HODE23, HODET4 etc.)
  • ABTX% (ie. ABTX34, ABTXJ8, etc...)
  • ABDT%
  • WEDT%

I know I can use the following formula for one of the 4 words, but I would like to know if there are formulas I could use where there are multiple words I need to pull out from a database. Any suggestions, tips, or resolution?

 

CONTAINS([Field 1],'HODE')

Alteryx
Alteryx

Are you using this within a filter tool? You can use the following formula in the custom filter expression box.

 

CONTAINS([Field 1],'HODE') OR CONTAINS([Field 1],'ABTX') OR CONTAINS([Field 1],'ABDT') OR CONTAINS([Field 1],'WEDT')

Highlighted
Asteroid

I don't know of a different way, so I'm interested to see what the Community come up with.

 

I usually use the filter tool with all of my specific words in OR statements one after the other -Contains([Field1],"HODE")

OR Contains([Field1],"ABDT")  et cetera.

 

At least you could have Alteryx help you write the conditional statement by inserting the words for you if you have more than a few to type.

Alteryx Partner

Hi @blitz45,

 

Filter tool would work fine in your case as suggested by @BrandonB  and @summarizer .

Meteor

Thank you so much! this worked!

Meteor

That's exactly what I did! thank you!

Labels