Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Filter Tool in Alteryx

rohit782192
11 - Bolide

Hello Alteryx Champ,

 

How can we search for a String that has include  and Or in it.

 

Is the Include is same as Contains.

 

 

 

5 REPLIES 5
binuacs
21 - Polaris

@rohit782192 Contains() function can be be used for include !Contains() works the opposite way

IraWatt
17 - Castor
17 - Castor

Hey @rohit782192,

Yeah you can use the contains function:

IraWatt_0-1654006535316.png

You can use the OR function like this if you have multiple checks

IraWatt_1-1654006596231.png

Contains([Line Description], "Tangoe") OR Contains([Line Description], "bob")
IraWatt
17 - Castor
17 - Castor

@rohit782192 Do you have some example data you are wanting to check?

phottovy
13 - Pulsar
13 - Pulsar

Hi @rohit782192 ,

 

If I am understanding your question correctly, you should be able to use the contains function inside a filter tool to accomplish this:

Contains([String],"include")
AND Contains([String],"Or")

phottovy_0-1654006663678.png

 

jacob_kahn
12 - Quasar

Sometimes I Use Contains() Sometimes I use IN

Labels