The use of a wildcard for a single string in a filter –for example, on a particular text field, I can enter the string ‘app’ and the successful and correct return of records containing ‘appendectomy’, ‘appendicitis’, and ‘appendix’ appear in the results.
But I want to search the same text field for records containing either ‘app’ or ‘perf’ or ‘rup’ anywhere in the text data when I apply the filter.
The letters I search on are different for each use, so a drop down list is not an option.
Another user may enter ‘robo’ or ‘poss’.
Does that help explain my question?
Diane Dowdell, RN|Supervisor. IT Clinical Systems |(954)276-4102| at TRC|Pager: (954)286-4216
Here is what I am thinking...
1. Create a Blank String Parameter
2. Create a function that will be used as a filter using the CONTAINS function. *NOTE Tableau does not a have a recursive function, nor multi value parameters, so you will need to define a "Deliminator" for your end users....
CONTAINS([Customer Name], SPLIT([Search Name],',',1))
(CONTAINS([Customer Name], SPLIT([Search Name],',',2)) AND LEN(SPLIT([Search Name],',',2)) != 0)
(CONTAINS([Customer Name], SPLIT([Search Name],',',3)) AND LEN(SPLIT([Search Name],',',3)) != 0)
3. Place that onto the Filter Shelf and Choose True. Then show your Parameter and test....
Not great, and could cause performance issues on larger workbooks, but this is what I'm thinking now.
I'll think on this more tonight, and see if there is a way to improve it.
Nice, Rody! That’s pretty much what I was thinking... You might be able to put all the splits into a single REGEX and therefore skip all the CONTAINS as well as the evaluation of 0-length strings.
REGEX crossed my mind, but thought it would result in a concatenation of all strings in the Param, thus (most likely) resulting in no matches.
That said, I have little experience with REGEX, so I'm going to explore that route now.