Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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
Top Solution Authors