Forum Discussion

donnellyk's avatar
donnellyk
Frequent Visitor
8 months ago
Solved

Using Google Matrix API to calculate distance between locations in my dataset

I have a dataset returning 77,000 records, each with both Buyer & Seller locations. The Seller location is always in the UK I'm trying to use the Google Matrix API to calculate distance between buy...
Need Help
  • donnellyk's avatar
    donnellyk
    8 months ago

    Thanks for your feedback, it helped point me in the right direction.
    Basically, I ammended my SQL query so that if it was a non UK address, I returned the address of the UK port of entry & then the google matrix api was able to calculate all the distances for me

GeraldGEmerick's avatar
GeraldGEmerick
Super User
8 months ago

donnellyk You are getting the Column1 error because it is returning an empty table.