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