Tableau’s Wildcard Match and Custom Value List filters are all well and good but they are limited. Both of them require that your search terms are in the correct order and the Custom Value List makes you click each individual item you want to include. For example, searching for “A4 Paper” would not return the [Product Name] “Paper A4”. This is an especially big problem if your field contains thousands of different values with little or no hierarchy to make your search easier.
This is where this Tableau trick can help. It allows you to search for multiple strings in any order, and Tableau will return a list of all items that contain all of those strings.