Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
agni_gold
Valued Contributor II

Extract latitude and Longitude using QV Script

I am trying to extract lat and lon from google map using following script.

address:

LOAD A as Address

FROM

(ooxml, no labels, table is Sheet1);

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

for i=0 to $(noRows)

let a=peek('Address',$(i),'address');

Data:

LOAD

'$(a)' as Address,

[result/geometry/location/lng] AS longitude,

[result/geometry/location/lat] AS latitude

FROM [http://maps.googleapis.com/maps/api/geocode/xml?address=$(a)&sensor=false];

drop Table address;

but when i load this script then an error comes [result/geometry/location/lng] not found .

but when i check http://maps.googleapis.com/maps/api/geocode/xml?address=Delhi&sensor=false

this link in internet file it will show same path as i used .

Please help.

1 Solution

Accepted Solutions
MVP
MVP

Re: Extract latitude and Longitude using QV Script

Hi,

Check this script, I am getting the values.  May be check whether the proxy is blocking any request.  In some companies they will block, you check in machine which has full internet access without any blocking.

GeocodeResponse:

LOAD status,  

    [result/geometry/location/lat] as [location/lat],

    [result/geometry/location/lng] as [location/lng],

    %Key_GeocodeResponse_62C7A0A69859D655    // Key for this table: GeocodeResponse

FROM [http://maps.googleapis.com/maps/api/geocode/xml?address=Delhi&sensor=false] (XmlSimple, Table is [GeocodeResponse]);

Regards,

Jagan.

2 Replies
MVP
MVP

Re: Extract latitude and Longitude using QV Script

MVP
MVP

Re: Extract latitude and Longitude using QV Script

Hi,

Check this script, I am getting the values.  May be check whether the proxy is blocking any request.  In some companies they will block, you check in machine which has full internet access without any blocking.

GeocodeResponse:

LOAD status,  

    [result/geometry/location/lat] as [location/lat],

    [result/geometry/location/lng] as [location/lng],

    %Key_GeocodeResponse_62C7A0A69859D655    // Key for this table: GeocodeResponse

FROM [http://maps.googleapis.com/maps/api/geocode/xml?address=Delhi&sensor=false] (XmlSimple, Table is [GeocodeResponse]);

Regards,

Jagan.

Community Browser