
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to convert address to GPS coordinates?
Hi guys,
I have 50 000 addresses and I need to show them on the map by converting to GPS coordinates. How can I do that, please?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Is it possible to show .qvw file in qlik sense or can you copy the script from this link please?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Table1:
LOAD
FirstName,
LastName,
Address,
City,
State,
Sales
FROM
state.xlsx
(ooxml, embedded labels, table is Sheet1);
let noRows = NoOfRows('Table1')-1;
for i=0 to $(noRows)
let d=peek('LastName',$(i),'Table1') & ', ' & peek('FirstName',$(i),'Table1');
let p=peek('Population',$(i),'Table1');
let address=peek('Address',$(i),'Table1') & ' ' & peek('City',$(i),'Table1') & ' ' & peek('State',$(i),'Table1');
Data:
LOAD
'$(d)' as Name,
'$(p)' as Population,
'$(address)' as Address,
subfield([Response/Placemark/Point/coordinates], ',' ,1) AS longitude,
subfield([Response/Placemark/Point/coordinates], ',' ,2) AS latitude
FROM [http://maps.google.com/maps/geo?q=$(address)&output=xml&oe=utf8&sensor=false&key=XXYYZZ] (XmlSimple, Table is [kml]);
next


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
you have a limit of 2500 api calls per day for free.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I am sorry, I am new in Qlik sense and do not know how to run it. How can I rewrite my script?
LOAD
NAME,
ADDRESS;
[TABLE1]:
SELECT
"NAME",
"ADDRESS"
FROM "XY"."TABLE1";
Address form is: Tigergasse 7, Vienna, 1080

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you help with my load script above please?
