1 2 Previous Next 28 Replies Latest reply on Sep 30, 2014 9:31 AM by Shawn Wallwork

    Issues with Tableau recognizing zip codes that begin with 0, help!

    M Panda

      Hello, I created a tool that identifies which state each zip code is in.  So for example, 08807 is in NJ.  I have created a "wildcard match" filter so people can enter in zip codes and the corresponding state will automatically appear upon entry.  The issue is zip codes that start with 0 are not recognized, so for 08807, I'd have to enter 8807.  Zip codes that start with 1-9 work perfectly fine.

       

      Not sure whether zip code should be a dimension or measure or what I need to do to get this to work.  Your help is appreciated.

        1 2 Previous Next