GeoAnalytics

[qliksus]

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?

[qliksus]

Much appreciated, Thank you .

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".

Many thanks in advance

[paolo_cordini · Accepted solution]

Hi

this should be the connector configuration in your case:

Regards

Paolo