Knowledge Drop

What format do state names need to be in for the map_layer_name: us_states to work

Userlevel 1

Last tested: Mar 7, 2019

According to our documentation, "us_states - Accepts full state names and two-letter state abbreviations."
In testing, the state name must be in Capitalized format like "Florida". All caps like "FLORIDA" or all lower case like "florida" will not be mapped.

A user who had the names in all caps came up with this
sql: concat(upper(substring(${TABLE}.state,0,1)),lower(substring(${TABLE}.state,1)));;

State values with whitespace surrounding also won't be mapped - you can use a TRIM() function around the state column to ensure this is not an issue.


This content is subject to limited support.                



0 replies

Be the first to reply!