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]);
next
