Skip to main content

Tableau is not properly recognizing my Australian postcodes. This is preventing postcode filled maps to display properly. I've confirmed the Postcode field in my data set is automatically associated with the 'ZIP Code/Postcode' Geographic Role.

 

For some reason, it appears Tableau is converting the 4-digit Australian postcodes in my data set to 5 digits, all with a leading zero. I believe that is preventing Tableau to associate the postcode values in my data set with the Australian postcodes used for mapping. Opening the 'Describe' dialog box by right-clicking on my Postcode field shows that the members in my data set all have a leading zero. I've run a few tests to a) change the datatype in Excel and b) to add a leading apostrophe in the Postcode in the Excel field. Neither affected the outcome.

 

Has anyone else encountered this issue? I'm running 8.2.4.

 

It appears it was working in 8.2.1 per Alan Eldridge's 15 August 2014 blog post here:

Australian Postcode Filled Maps now in Tableau 8.2.1 | Alan@Tableau

 

Looking forward to hearing if anyone has found a resolution to this!

Australian postcodes converted to 5-digits with leading zero, preventing proper display in maps

15 answers
  1. Nov 12, 2014, 11:54 AM

    Steven welcome back to the forums!

     

    I can confirm that the Aus postcodes are not working properly in 8.2.2 either. Tableau is adding the extra leading zero. But the workaround is quite simple. Go to Edit Data Source, then click on the globe icon under 'Postcode' and make it a string type. The globe will remain, but the leading 0 will disappear.

     

    Steven welcome back to the forums! I can confirm that the Aus postcodes are not working properly in 8.2.2 either. Tableau is adding the extra leading zero. But the workaround is quite simple.

    (See attached.)

     

    You should probably send a note to Customer Support, as I don't think this should be the expected behavior.

     

    Cheers,

     

    --Shawn

     

    PS: In the future it would save us a bit of time if you posted a sample packaged workbook, so we don't have to spend time regenerating a bit of your data to answer your question. Thanks.

0/9000