KNOWLEDGE BASE

Zip Code Not Automatically Parsed From Address Field


Published: 30 Oct 2019
Last Modified Date: 29 Sep 2020

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?