KNOWLEDGE BASE

Using Japanese Postal Codes


Published: 10 Dec 2015
Last Modified Date: 14 Dec 2015

Question

How to use Japanese postal codes in Tableau Desktop.

Environment

Tableau Desktop 9.2 and later versions

Answer

Tableau Desktop recognizes only the first three digits of Japanese postal codes. The following instructions demonstrate how a calculated field can be used to display only the first three digits of a seven-digit postal code.  
  1. In Tableau Desktop 9.2 or later, connect to a data source that has seven-digit Japanese postal codes.
  2. In the Data pane, right-click the postal code dimension and select Change Data Type > String.
  3. Click Analysis > Create Calculated Field and create a calculated field to split the first 3 digits from the remainder of the postal code. For example: 
    LEFT([Postal Code],3)
  4. Right-click the new calculated field and select Geographic Role > ZIP Code/Postcode.
Did this article resolve the issue?