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
Solved! Go to Solution.
You can use filter tool with following expression
[Name] = "A"
or
[Name] = "B"
or
[Name] = "C"
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")
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.
Part time Tableau, Part Time Alteryx. Full Time Awesome
Assuming A, B and C represent the full strings you are looking for, this is simpler:
[NAME] in ("A","B","C")
THANKS IT WORKED WELL