Generate latitude and longitude from city or Place

[fkeuroglian]

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

[Brett_Bleess]

Believe you are likely looking for the following:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/Scrip...

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/File_Wizard_Typ...

Regards,
Brett