Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Find number of stores within specific radius

prravich
7 - Meteor
Hi all

I have a file having locations of store within US. Let’s say there are 100 rows for 100 stores. I want to find out for any given store , how many stores are within its 10 mile radius. Any thoughts on easiest way to accomplish this ?
4 REPLIES 4
KaneG
Alteryx Alumni (Retired)

Hi @prravich,

 

A trade area and then Spatial Match tool will work. The Trade area will build a polygon of 10 mile radius and then plug that and the original data back into a spatial match to get all the stores falling within those Polygons.

prravich
7 - Meteor
I have trade area built for every store. But I’m having trouble doing spatial match for every row. I think I need to duplicate rows but figuring an easier solution. Can you please post an example with just ten rows ?
KaneG
Alteryx Alumni (Retired)

I've included a couple of examples. The Find Nearest Tool may even end up being easier.

 

Note: I've set limits to 2km, as I created my points too close together...

prravich
7 - Meteor

Thank you so much KaneG, that worked exactly the way I wanted to. Appreciate your help.

 

My distance is 50miles and the nearest distance tool only supports up to 20 nearest points so I went with spatial match tool instead.

Labels
Top Solution Authors