Alteryx Designer Desktop Discussions

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

how to find customers with in radius circle

rag329
8 - Asteroid

Hi team. 

 

I have Customers data with latitude and longitude and

            store data with coordinates.

 

how to find customers with in 2 miles radius. 

 

please help. Thanks in advance. 

 

help me with the approach. 

 

I have got the customers in the radius but unable to filter those customers in the radius

5 REPLIES 5
ed_hayter
12 - Quasar

A spatial match between your trade area circle and the points and then when the circle contains points should filter the data to only the relevant values.

 

So in the input anchor for points you want a row for each person. Then for the other input anchor a row for each circle that you are checking

rag329
8 - Asteroid

@ed_hayter thank you so much I will check that 

Felipe_Ribeir0
16 - Nebula

Hi @rag329 

 

Another way of approaching this problem, you can calculate the distance between each customer and the store, and then filter the distances that are acceptable. The example of the distance tool is a good way of showing what i mean, just put a filter after of the result of this tool.

dis.png

 



 

 

 

 

 

Screenshot 2023-08-29 114308.png

rag329
8 - Asteroid

@ed_hayter i have tried but in match anchor i should get those  8 points but it didnt happen. guide me

ed_hayter
12 - Quasar

So for your universe anchor it is going to match for each circle you generate. So it is matching for each trade area generated returning all the points within each one. You can either only send through the one trade area of interest into the universe anchor. Or Filter the outcome to only the spatial object of interest after the match So you need to filter on the trade area that contains those 8 points of interest.

Labels
Top Solution Authors