2 Replies Latest reply: Nov 16, 2016 12:31 PM by Enrique Ortiz RSS

    How to create a geomakepoint dimension when fetching lattitude and longitude from database.

    laxman V

      How to create a geomakepoint dimension when fetching lattitude and longitude from database.

        • Re: How to create a geomakepoint dimension when fetching lattitude and longitude from database.
          MARCO HADIYANTO

          Hi Laxman,

           

          Let say you have this coloumn in your table.

          A

          Country

          Longitude

          Latitude

           

          Are you using data manager or load editor? If you're using load editor then you should do scripting.

          Connect to .... (yourdatabase)

          Load Country,

                   Longitude,

                   Latitude,

                   Geomakepoint(Latitude, Longitude) as Point;

          SQL Select * From A;

          //let say this query to load data from your database, then what you should do is adding load before sql select and put geomakepoint there.

           

           

          Regards,

            • Re: How to create a geomakepoint dimension when fetching lattitude and longitude from database.
              Enrique Ortiz

              What about Data Manager?

               

              I have Qlik Sense Desktop and it doesn't recognize my City or State fields from my WarehouseLocation table.  I'm loading data from our SQL server.  I went so far as combining the Lat & Long together directly in my SQL server to see if Qlik would recognize the field as a Geo location but doesn't work.  I do not want to write out a scrip like your example above because the Data Manager doesn't allow me to make associations with tables done through Load Scrip Editor. Is there a way to force Load Manager to recognize a specific field as GeoLocation but not have to use Load Editor Scrip to do so?