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