Load Data Google Maps for beguinner

theboss-123 — Tue, 02 Nov 2021 14:17:49 GMT

Hello ,

following the guide

Document preview of Steps to Implement Google Map in Qlikview.docx

when i try to load data i got erros "symantic erro
for i=0 t"

my script is bellow :

Customer_info:
LOAD FirstName,
LastName,
City,
ProductSold
FROM
[C:\Users\secre\OneDrive\Documents\01_UNIMER GROUP\12_WORK QLIKVIEW\work a valider\Left Join\Google Maps LAB\Customer_info.xls]
(biff, embedded labels, table is Sheet1$);

let noRows = NoOfRows('Customer_info')-1;

for i=0 to $(noRows)

let a=peek('FirstName',$(i),'Customer_info');
let b=peek('LastName',$(i),'Customer_info');
let c=peek(‘ProductSold’,$(i),'Customer_info');
let address=peek('City',$(i),'Customer_info');

Data:
LOAD
'$(a)' as FirstName,
'$(b)' as LastName,
'$(c)' as ProductSold,
'$(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]);

Re: Load Data Google Maps for beguinner

theboss-123 — Tue, 02 Nov 2021 14:16:46 GMT

i updated the script but now i got error

topic Re: Load Data Google Maps for beguinner in QlikView

Load Data Google Maps for beguinner

Re: Load Data Google Maps for beguinner