Geoanalytics Map with zip code of customized territory
Hi Team,
We have two tables , one is having Country, District, Territory, Value and the other one is having the Teritory & Zipcode mapping. Since the key field Territory is a customized as per the organization we are struggling the define boundary in area map based on zipcode. Basically we are trying to create a area & bubble layer using the US zipcode mapped to territory. Can it achieved using the Open Street Map or Geoanalytics Connector?
Fyi.. i have attached the sample zipcode, could any please suggest?
Will it work if i split the single table into two tables as in below .
T1: REGION_ID, DISTRICT_ID, TERRITORY_NUMBER, VALUE
T2: TERRITORY_NUMBER, ZIPCODE, COUNTRY
In the operation , what should be the input for "Loaded Table Name ", "Key" since the REGION_ID& ZIPCODE both are in different tables not in a single table and we want to dissolve based on the field "REGION_ID".
