Discussion board where members can get started with QlikView.
Can anyone help me on how we can get lat long using google API, below is sample API that i am planning to use below API
Any help in this regard will be appreciated.
This script should do the trick
///////////////replace here the call for your table //////////////////
(ooxml, embedded labels, table is Sheet1);
let noRows = NoOfRows('Addresses')-1;
for i=0 to $(noRows)
'$(d)' as ID,
[result/formatted_address] as FormattedAddress,
[result/geometry/location/lat] AS latitude,
[result/geometry/location/lng] AS longitude,
FROM [http://maps.googleapis.com/maps/api/geocode/xml?address=$(address)&sensor=false] (XmlSimple, Table is [GeocodeResponse]);
Thanks for your reply. This is helpful also can you please help me if I can get a lat long if I provide city/town/county as input parameter to this API.
Thanks in advance