Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
ALTER.NEXT:

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

SAVE YOUR SPOT
It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!
SOLVED

Only records with intersections of one data set

Highlighted
Alteryx Certified Partner

Ok, philosophical approach to what should be an easy question. 

 

One data set:  each record has a lat/long

Created a centroid from lat/long

Created a trade area 5 mile radius for each centroid

(easy so far)

want to understand and have a data set with 'only' the intersections of those trade areas in my single data set. 

 

Spatial process wants 2 different data sets to create intersection. 

 

Don't care about the extra, I only want the intersections of my trade areas. 

 

Approaches?

Highlighted
Alteryx Partner
Alteryx Partner

Hi @WaterMark,

 

Did you try Spatial Match tool to check if it satisfy your desired output?

Thanks.

 

Sapna Gupta
Highlighted
Alteryx Certified Partner

I don't have 2 data sets. I don't have a target and a universe. I only have a single set from which I've created centroids, and trade areas off those centroids.  Want to know where the trade areas intersect. 

Highlighted
17 - Castor
17 - Castor

Hi @WaterMark 

 

In your case, feed the records into both the Target and Universe Inputs of the Spatial Match tool.  It will spit out pairs of trade areas that intersect.  After removing the records when the a trade area intersects itself, use a Spatial Process to create the intersections.  

 

WF.png

 

Resulting in 

 

map.png

 

Dan

Highlighted
Alteryx Certified Partner

Thanks for the help. This isn't what I used, but it gave me a couple ideas that I used to solve my problem. 

Highlighted
Alteryx Certified Partner

accidental duplication

Highlighted
17 - Castor
17 - Castor

You're welcome @WaterMark 

 

Glad to help

 

Dan

Labels