3 Replies Latest reply on Aug 9, 2018 12:51 AM by Loretta Xia

    Exact Match

    Loretta Xia

      Hi buddies,

       

      I'm studying how to get the parameter to be able to select multiple values and luckily Tableau has a perfect solution already:

      Create a Multiple Value Selection Parameter | Tableau Software

      However, the 2 options in this post are based on SUBSTRING Match not an exact match.

       

      For instance, the string in my parameter [Multi-Search] is: "LA"

      Using

      CONTAINS([Multi-Search],[State])

      OR

      REGEXP_MATCH([State],REPLACE([Multi-Search], "," , "|" ))

      would both return true for "LA" and "LALA LAND" while I only need LA.

       

      Does anyone know how to do EXACT MATCH in Tableau?

       

       

      Thanks a lot

      Loretta