Filter Tool in Alteryx

[rohit782192]

Hello Alteryx Champ,

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

Is the Include is same as Contains.

[binuacs]

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

[IraWatt · Accepted solution]

Hey @rohit782192,

Yeah you can use the contains function:

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

Contains([Line Description], "Tangoe") OR Contains([Line Description], "bob")

[IraWatt]

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

[phottovy · Accepted solution]

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")

[jacob_kahn]

Sometimes I Use Contains() Sometimes I use IN