Alteryx Designer Desktop Discussions

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

Is it possible to make alteryx workflow same as ArcGIS UNION ?

Astrophy1
6 - Meteoroid

Hi there

 

My customer require alteryx macro that the function is the same ArcGIS UNION.

Is it possible to make alteryx macro?

 

How ArcGIS Union (Analysis) works, see below the picture.

10 REPLIES 10
StephenR
Alteryx
Alteryx

Look at the Spatial Process tool. Create Intersection Object will give the same result.

 Alteryx spatial union.JPG

Regards,
Stephen Ruhl
Principal Customer Support Engineer

Philip
12 - Quasar

If you are trying to union two layers, the attached workflow shows how to do it. The key is to find the intersecting areas, then cut those areas out from the original shapes, then union everything back together.

 

Let me know what questions you have.

Philip
12 - Quasar

Here's a macro version.

Astrophy1
6 - Meteoroid

Hi Philip

 

Thank you for your interest and effort.

I tested your macro by a various case. But it didn't exactly work as ArcGIS union.

Two circle intersected area must can be created another new feature.

Seeing this picture, We will find that there is the union macro somewhat different it.

http://pro.arcgis.com/en/pro-app/tool-reference/analysis/how-union-analysis-works.htm

Union example 1

I think that two circle shape create new feature using the summarize spatial create intersection.

What are you thinking about?

Philip
12 - Quasar

Sorry, Union isn't consistent with how Intersect works. Let me go fix it.

Philip
12 - Quasar

Here's the fixed version. I haven't tested performance on a large data set, so there may be places for improvement.

Astrophy1
6 - Meteoroid

Sorry for a late feedback.
You hav very wonderful skill. I think this issue is almost solved by your macro. But some issue still have.
I tested by the same polygon shape files at ArcGIS and Alteryx.
The result of Alteryx was bit different from ArcGIS Union.
This is execution result screen.
See the last picture, I think that the difference is what an intersected two polygon in the same layer don't be split.
I think maybe it be used summarize spatial create_intersection.
Thanks

Philip
12 - Quasar

That's interesting. It looks like ArcGIS kept sliver polygons, while Alteryx cleaned them up. What's the area of those differences in square meters? Can you send the two shapefiles to me?

Astrophy1
6 - Meteoroid

Thank you for assistance.

I attach actual tested file. This is the Land Use Zoning Map of korea.

 

https://drive.google.com/file/d/0Bzi69qFmKjtqdWRDUDFrNFJEMFE/view?usp=sharing

Labels