This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
You have addresses, but do you have spatial objects? The spatial functions in Alteryx require spatial objects. If you have an address and want the spatial information, you'll need to geocode those addresses to return latitude/longitude values (which can be turned into spatial objects).
There is a geocoding macro and dataset available from Alteryx, but it is a paid add-on and not included with the base Designer installation. Alternatively, if there aren't that many records, you could just manually Google each one and obtain the latitude/longitude values from Google.
Once you have latitude/longitude values, you can use the Create Points tool in Alteryx to create spatial objects. From there, there's a couple ways to obtain the within 5km matches you're looking for that we'll talk about once we have those spatial objects.
Ok great! I've put together the attached example to show a few different ways the spatial process can be achieved with different spatial (and non-spatial) tools. Check it out and let me know if any of these work for you.