I working for a client which has multiple stores around the country. My client offers a loyalty program. I have the home address for all loyalty members, and of course the street address of all stores. I would like measure the distance from each clients address to the nearest store. What is the best way to do that in DataIku? Is there a particular plugin I need to install?
You can use the geocoding plugin on both datasets: https://www.dataiku.com/dss/plugins/info/geocoder.html. That will give you one new GEOPOINT column for each of the 2 datasets (stores and clients). You can decompose these GEOPOINTs in latitude and longitude.
Then you can use the "Geo-join" processor of a visual Prepare recipe to compute the "distance from store" column.
Hi, The Bing geocoder is working fine on my side. Have you installed the latest version of the geocoder plugin (1.0.9)? Have you followed the instructions on https://www.bingmapsportal.com/ to get an API key?
There is a geo-join processor (https://doc.dataiku.com/dss/latest/preparation/processors/geo-join.html) in the Prepare recipe that should do it. You would create the Prepare recipe on the customer data, and then join the store data to it with the geo-join processor.