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

donnellyk's avatar
donnellyk
Frequent Visitor
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

v-menakakota's avatar
v-menakakota
Community Support
8 months ago

Hi donnellyk ,

Glad to know that your issue is now resolved. Thanks for sharing your approach, and please continue to use the Fabric Community for any future questions or support.

Best Regards, 
Community Support Team