I have a .csv with columns like: origin country, origin city, ZIP, latitude, longitude and destination country, destination city, ZIP, latitude, longitude.
How can I get another field with the distance (Km by road) in between the Origin and Destination City?
Hi @Inactive User ,
I believe Alteryx can only estimate distances as the crow flies and only for the US there is an extra pack for drivetime supported by TomTom.
As an alternative, there are API's that provide that information for free. I think mapbox is one of them (https://docs.mapbox.com/api/overview/)
and GMaps mey have a similar feature.
Regards,
Angelos
@Inactive User
Just add to @AngelosPachis , there is one option in Alteryx to calculate the Drive Time and Distance, with extra licensed dataset.