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

[laxmanqlik]

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

[marcohadiyanto]

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,

[#3]

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?