KNOWLEDGE BASE

Creating a Map from Data with Mixed State Names and Abbreviations


Published: 20 Feb 2013
Last Modified Date: 31 Aug 2016

Issue

How to create a filled map from a data source with mixed state names and abbreviations.

Environment

Tableau Desktop

Resolution

Create calculated field to convert State names to abbreviations. 

Example formula: 

 
Case UPPER([State]) 
When "WASHINGTON" then "WA" 
When "OREGON" then "OR" 
When "FLORIDA" then "FL" 
else [State] 
End

 
 
Did this article resolve the issue?