Hello
I searched the community and I found that there was a qvw file to generate longtitude and latitude, which looks great.so I copied the file and made it mine,
but it does not created the longtitude and latitude for me.
Why?
Table1:
LOAD %OpptyID,
Address,
City,
State,
[Postal Code]
FROM
C:\QVW\Skyline.xls
(biff, embedded labels, table is [Sheet1$]);
let noRows = NoOfRows('Table1');
for i=0 to $(noRows)
let d=peek('%OpptyID',$(i),'Table1') ;
// let p=peek('Population',$(i),'Table1');
let address=peek('Address',$(i),'Table1') & ' ' & peek('City',$(i),'Table1') & ' ' & peek('State',$(i),'Table1')&' ' &peek('Postal Code',$(i),'Table1');
Data:
LOAD
'$(d)' as Name,
// '$(p)' as Population,
'$(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
Do i have to get the key myself? It says if you create on your local machine, it will skip the key checking.
What did i do wrong?
Thanks
