KNOWLEDGE BASE

Brazilian Postal Codes (CEP) Mapping Incorrectly


Published: 14 Mar 2018
Last Modified Date: 14 Mar 2018

Issue

When mapping a Brazilian postal code, the mark shows up in the wrong place.

Environment

Tableau Desktop

    Resolution

    Ensure that the CEP field contains only a 5 digit code.  If the data contains more than 5 digits, like all 8, a calculation can be used to separate the numbers:

    LEFT( STR( [CEP] ),5 )

    For example, 26178400 will map erroneously in Mato Grosso, but the code resulting from the above calculation, 26178, maps properly in Rio de Janeiro.

    Cause

    Tableau only recognizes 5 digit CEP codes.
    Did this article resolve the issue?