KNOWLEDGE BASE

Creating a Map from Data with Mixed State Names and Abbreviations


Published: 20 Feb 2013
Last Modified Date: 27 Sep 2017

Issue

You are unable to create a 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?