topic Re: EXTRACT GOOGLE lat and lng using QV script in QlikView

EXTRACT GOOGLE lat and lng using QV script

agni_gold — Sat, 07 Dec 2013 17:42:26 GMT

I an trying to extract google lat and lng using following script , but it gives error : [result/geometry/location/lng] not found

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;

Please help

Re: EXTRACT GOOGLE lat and lng using QV script

afurtado — Mon, 09 Dec 2013 01:19:06 GMT

Hi.

I'm using geocoding.qvw.

I have a different "from".

FROM [http://maps.google.com/maps/api/geocode/xml?sensor=false&ie=utf8&region=$(vTLD)&address=$(vAddress)] (XmlSimple, Table is [GeocodeResponse])

you need to set up some variable before (inside for...next)

Alessandro Furtado

Re: EXTRACT GOOGLE lat and lng using QV script

jagan — Mon, 09 Dec 2013 02:24:03 GMT

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.