KNOWLEDGE BASE

Zip Code Not Automatically Parsed From Address Field


Published: 30 Oct 2019
Last Modified Date: 31 Oct 2019

Issue

An address field set to 'Zip' geographic role returns Null rather than parsing the zip code from the end of the field.

Environment

Tableau Desktop 2018.3 and later versions

Resolution

If [field] is the address column, the following can be used to parse out a zip code from the end: SPLIT([field], ' ', -1)

Cause

It is not currently possible to of ad-hoc resolve addresses into postcodes.
Did this article resolve the issue?