Get geolocation (latitude and longitude) using Google API
I have an issue when getting the latitude and longitude for a city. The problem is as follows: roci
Lets say I have 10 cities. I run the script below. The first time I get a result for 8 cities, the next time for 7, then for 5 or 8, but never the full 10. The result is totally random. So, the first time city A can be found, the next time the result is empty. What am I doing wrong?
Location: LOAD City , Country FROM [Dimensions QVD\LocationTmp.qvd] (qvd) ;
Let noRows = NoOfRows('Location')-1;
for i=0 to $(noRows) let b = peek('City',$(i),'Location'); let c = peek('Country',$(i),'Location');