Alteryx Designer Desktop Discussions

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

Filter tool

razzy
8 - Asteroid

I need help in using the filter tool  to query a column with there inputs for example 

 

Custom Filter: Contains ([Name], "A", "B", "C") : where Name is the column name:

when i run it , it returns a parse error

6 REPLIES 6
ponraj
13 - Pulsar

You can use filter tool with following expression 

 

[Name] = "A"
or
[Name] = "B"
or
[Name] = "C"

razzy
8 - Asteroid

No that is not working sorry, i am still having the same error what i want to do is like using a wild card to pull up data from the column name,

 

Contains([NAME],"A" Or B")

LordNeilLord
15 - Aurora

Hey @razzy

 

Unfortunately if you want to use contains, you need to write them all out like this:

 

Contains([Name], "A") || Contains([Name], "B") || Contains([Name], "C")

If you have lots to do then Find & Replace might be the way to go.

 

Conatins.PNG

 

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome


Data Lover

PeterGoldey
11 - Bolide

Assuming A, B and C represent the full strings you are looking for, this is simpler:

 

 

[NAME] in ("A","B","C")

razzy
8 - Asteroid

THANKS IT WORKED WELL

ponraj
13 - Pulsar
You can also accept the solution which helped you to resolve the problem.

Regards,
ponraj
Labels