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

Knowledge Drop

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.                

Version history
Last update:
‎05-07-2021 09:48 AM
Updated by: