5 Replies Latest reply on Apr 4, 2018 9:50 AM by Galen Busch

    Recognizing all CAPS and lower case as one

    Nathan Schwinnen

      Is it possible for Tableau to recognize words that are spelled the same thing regardless of whether it is all CAPs or not?  For instance, I have a category for "City".  On one line of the data, the city may be Detroit and then on another it is DETROIT.  I want Tableau to recognize these as the same.

       

      I am dealing with shipment data, so I have multiple columns where this would be useful.  I have Origin City and Destination City and other columns such as customer names can also have the same issue.  As is stands now, I have to constantly check my data for these issues and create groups.

       

      If anyone has a solution, I would appreciate the assistance.