6 Replies Latest reply: Jan 26, 2016 4:40 AM by Marco Puccetti RSS

    KML and Geolocation

    Marco Puccetti

      Hello! i need to obtain an Italy Map that contains for each region the amount of IMPORT field.

      This is the Table structure:

       

      NDGTIPO_PAGCITTAPROVINCIAABIDATA INCASSOIMPORTOLATITUDELONGITUDE
      1223456COPisaPI516407/04/201520.000,0043.71613510.3966024

       

      When i attach these data to the map the region linking is not done, but the Sum(IMPORTO) is linked to every region.

      I have also used this statement to have a correct coordinate linking:

       

      LOAD

          NDG,

          TIPO_PAG,

          CITTA,

          PROVINCIA,

          ABI,

          "DATA INCASSO",

          IMPORTO,

          LATITUDE,

          LONGITUDE,

          GeoMakePoint(LATITUDE,LONGITUDE) AS LOCATION

      FROM [lib://Downloads/GEOMAPS.xlsx]

      (ooxml, embedded labels, table is Foglio1);

       

      What have i to do to render for each region (City) with circles the amount of data?

      Is it necessary to mantain a certain table structure to obtain this?

       

      Thanks