In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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