Dear all,
I am now facing a problem really need your help.
1. I just get nothing when loading the following script:
Table1:
LOAD FirstName,
LastName,
City,
[Products sold] as 'ProductSold'
FROM
[..\..\internal projects\QV\QV technical documents\googlemap\Customer_info.xlsx]
(ooxml, embedded labels, table is Sheet1);
let noRows = NoOfRows('Table1');
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=$(C)&output=xml&oe=utf8&sensor=false&key=XXYYZZ]
(XmlSimple, Table is [kml]);
next
it seems that the it still doesn't work when i change the "XXYYZZ" to the key i get from google.
therefore, i can't get the longitude and latitude value.
2. from previous discussion from community, i know that API of google has been changed, i should do some change in the 'color' tab:
='http://maps.googleapis.com/maps/api/staticmap?center='
& num(var_mid_lat, '##############', '.', ',' )
& ',' & num(var_mid_long, '##############', '.', ',' )
& '&zoom=$(var_zoom)'
& '&maptype='&var_maptype
& '&size='&map_size_x&'x'&map_size_y
& '&key='&gmap_key & '&sensor=false'
however, before i develop the chart, should i load longitude and latitude first???????
really need your help~~
thanks~~
Manie
