Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts!
I would like to know if there is some macro, or qvw to generate lat long based on a city or a place.
I am trying with the :
GeocodeResponse:
LOAD
'$(b)' as City,
([result/geometry/location/lat]) as latitude,
([result/geometry/location/lng]) as longitude
FROM [http://maps.googleapis.com/maps/api/geocode/xml?address=$(b)&sensor=false] (XmlSimple, Table is [GeocodeResponse]);
next i;
But do not generate the fields, í suppose the api is down or not function any more
Thanks a lot
Fernando
Believe you are likely looking for the following:
Regards,
Brett