We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Spatial Match Tools and Combining Data

ijurgensen
7 - Meteor

Hello!

 

I have two spatial match tools, each combining a state boundary and a number of centroids contained within the state, and I'm trying to re-join the data to do further analysis and compare data between two states. 

 

When I add a union tool to the "M" field of each spatial match tool, it outputs a bunch of null fields. However, when I view the "M" field of each spatial match tool via a browse tool, I can see all the data that I'm trying to combine.

 

Any tips?

4 REPLIES 4
AngelosPachis
16 - Nebula

Hey @ijurgensen ,

 

Do the field names between the two "M" anchors of your spatial match tools have the same names? 

 

If your Union is set to Auto Config the fields by Name, then if the field names differ that will possibly be the cause of your Nulls. Any chance you can attach a screenshot so we can get a better understanding of the issue?

 

Thanks

 

Angelos

Qiu
21 - Polaris
21 - Polaris

@ijurgensen 
As suggested by @AngelosPachis , if you dont what to change the names of the fields, then manully arrange the postion of fields.

Qiu_0-1603927112910.png

 

ijurgensen
7 - Meteor

The field names should be the same, as they're coming from the same source and I don't change them anywhere in the workflow. I've attached a screenshot. I tried manually configuring by name/position and neither worked. Thank you for your help in this!

ijurgensen
7 - Meteor

I figured this out. For some reason in the spatial match tool there were a number of records deselected that caused the data to not come through. Noob mistake, thank you!

Labels
Top Solution Authors