Zip Code Formatting

Can somebody please explain zip code formatting necessary to recognize ZIP in the US?  I have full length zip codes (9 digits) and ThoughtSpot doesn't appear to recognize them as such.  I have created a function to truncate the Zip to 5 digits and then GeoConfig, which works, but performance is slower (can do ETL to truncate zips but would like to keep full zip-codes if possible)  Can TSpot only handle 5 digit zips in the US?  

It may be necessary to update the documentation to elaborate on recognized number/string formats for zip/state/province within each GeoCode.


Reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 11 mths agoLast active
  • 16Views
  • 3 Following