1 Reply Latest reply on Dec 22, 2011 10:59 AM by Shawn Wallwork

    9 digit zip

    Burt Dietz

      I have a file that has 9 digit zip codes that Tableau does not recognize.  Is there a calc to change 9 digit zip to 5 digit zip?

        • 1. Re: 9 digit zip
          Shawn Wallwork

          Burt, first thing to try is manually assigning it a geography (Rt-click Geography Role\ Zip Code/Postal Code) If that doesn't work put this in a calculated field:

           

          LEFT(STR([ZIP/Postal Code]),5 )

           

          Then you'll need to manually assign the geography to this field. Hope this helps.

           

          --Shawn