google maps do not work for me?

alexpanjhc — Wed, 15 May 2013 14:19:31 GMT

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

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

topic google maps do not work for me? in QlikView

google maps do not work for me?