0 Replies Latest reply on Nov 1, 2018 7:20 AM by Edward Stewart

    Creating map cluster visualisation based on Zip Code/Postcode

    Edward Stewart

      Hi,

       

      I would like to create visualisations using Zip Code/Postcode data for all the countries on the globe.  I have the postcodes and the countries so in theory Tableau will do the mapping...

       

      Problem. For data privacy reasons I don't want to identify distinct postcodes locations rather the district/county, ie the first three characters in Canada, three in the UK, India 6 etc.  My question is there a list that somebody has developed for all countries?  Something like this.

       

      IF [Country] = 'CA' THEN LEFT([Postal],3) //Canada

      ELSEIF

      [Country] = 'GB' THEN LEFT([Postal],3) //UK

      ELSEIF

      [Country] = 'IN' THEN LEFT([Postal],6) //India

       

      etc

       

      END

       

       

      Doing this for 200 plus countries is painful, also despite the helpful Tableau postcode page some countries just plain don't work.