Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

How to convert address to GPS coordinates?

Hi guys,

I have 50 000 addresses and I need to show them on the map by converting to GPS coordinates. How can I do that, please?

6 Replies

Re: How to convert address to GPS coordinates?

Not applicable

Re: How to convert address to GPS coordinates?

Is it possible to show .qvw file in qlik sense or can you copy the script from this link please?

Re: How to convert address to GPS coordinates?

Table1:

LOAD

     FirstName,

     LastName,

     Address,

     City,

     State,

     Sales

FROM

state.xlsx

(ooxml, embedded labels, table is Sheet1);

let noRows = NoOfRows('Table1')-1;

for i=0 to $(noRows)

  let d=peek('LastName',$(i),'Table1') & ', ' & peek('FirstName',$(i),'Table1');

  let p=peek('Population',$(i),'Table1');

  let address=peek('Address',$(i),'Table1') & ' ' & peek('City',$(i),'Table1') & ' ' & peek('State',$(i),'Table1');

  Data:

  LOAD

  '$(d)' as Name,

  '$(p)' as Population,

  '$(address)' as Address,

  subfield([Response/Placemark/Point/coordinates], ',' ,1) AS longitude,

  subfield([Response/Placemark/Point/coordinates], ',' ,2) AS latitude

  FROM [http://maps.google.com/maps/geo?q=$(address)&output=xml&oe=utf8&sensor=false&key=XXYYZZ] (XmlSimple, Table is [kml]);

next

agigliotti
Honored Contributor II

Re: How to convert address to GPS coordinates?

you have a limit of 2500 api calls per day for free.

Not applicable

Re: How to convert address to GPS coordinates?

I am sorry, I am new in Qlik sense and do not know how to run it. How can I rewrite my script?

LOAD

NAME,

ADDRESS;

[TABLE1]:

SELECT

"NAME",

"ADDRESS"

FROM "XY"."TABLE1";

Address form is: Tigergasse 7, Vienna, 1080

Not applicable

Re: How to convert address to GPS coordinates?

Can you help with my load script above please?