8 Replies Latest reply on Jul 2, 2018 9:31 AM by wdy Chen

    How to stop tableau reading my zip codes as numbers?

    wdy Chen

      Hi,

       

      I have a zip code column which contains mostly US zip codes and some CA zip codes. When connecting my datasource(csv), Tableau automatically reads my zip code column as numerical and converts the CA zip codes as NULL. Converting this column back to character doesn't bring the information back. Is there any way to have tableau read the zip codes as is? There's a work around that to add a couple of letters to the column in the original datasource, like US012345, then remove the letters in Tableau. But I hope there's a better way to do it.

       

      BTW, does anybody know how to mark a correct answer?

       

      Thanks,

      Chen