Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am learning Qlikview and faced below issue while implementing google maps . I am using attached PDF as reference to do this scenario.
Code is as below :
Table1:
LOAD FirstName,
LastName,
City,
ProductSold,
Year
FROM
(ooxml, embedded labels, table is Sheet1);
let noRows = NoOfRows('Table1')-1;
for i=0 to $(noRows)
let a=peek('FirstName',$(i),'Table1');
let b=peek('LastName',$(i),'Table1');
let c=peek('ProductSold',$(i),'Table1');
let address=peek('City',$(i),'Table1');
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] (XmlSimple, Table is [Data]);
next i;