Joining Layers in ArcGISPro

728
8
10-03-2018 10:48 AM
MichelleCouden
Occasional Contributor

I am joining 2 layers (i.e. attribute tables). I am trying to get all values to show up in both layers in the join. In stead, I get the features that are related and then it nulls out the rest. Am I missing a step in Pro??

0 Kudos
8 Replies
RichRuh
Esri Regular Contributor

Hi Michelle,

Could you please provide a code snippet showing what you are trying to accomplish?

Thanks,

--Rich

0 Kudos
MichelleCouden
Occasional Contributor

So, I would be joining 2 layers with the field BridgeID in both tables. The end result I would like them to be joined by Bridge ID and also have all information in the fields showing. Right now, when I join by Bridge ID the joining layer has null’s if there is not a match. I don’t want any nulls. Please let me know if that helps.

Michelle Couden

Cartographer

Certified GIS Analyst

TPP Wellness Contact

Transportation Planning and Programming

Traffic Analysis Section

(512)486-5136

Watch for Cyclists!

0 Kudos
RichRuh
Esri Regular Contributor

Michelle,

Are you trying to do this with the ArcGIS Pro user interface or with C# code?  If you're doing it with C# code, what classes are you trying to use?

Thanks,

--Rich

0 Kudos
MichelleCouden
Occasional Contributor

ArcGIS Pro. I was hoping they made the joining tables/layers improved.

Michelle Couden

Cartographer

Certified GIS Analyst

TPP Wellness Contact

Transportation Planning and Programming

Traffic Analysis Section

(512)486-5136

Watch for Cyclists!

0 Kudos
RichRuh
Esri Regular Contributor

Michelle--

Ah, ok.  This is the software development kit forum.  I think if I tag ArcGIS Pro‌ they will see it, but you might also try posting it  at the Ask ArcGIS Pro section of GeoNet.

0 Kudos
MichelleCouden
Occasional Contributor

Thank! I couldn’t find the tag for just Pro. I appreciate it.

Michelle Couden

Cartographer

Certified GIS Analyst

TPP Wellness Contact

Transportation Planning and Programming

Traffic Analysis Section

(512)486-5136

Watch for Cyclists!

0 Kudos
MichaelVolz
Esteemed Contributor

Are you able to perform this same join in ArcMap without getting null values if the joining layer does not match?

0 Kudos
MichelleCouden
Occasional Contributor

I tried in ArcMAP as well. It doesn’t keep the values in the records. I thought there was a way of joining and keeping all information in both tables. I’m thinking I’m wrong.

Michelle Couden

Cartographer

Certified GIS Analyst

TPP Wellness Contact

Transportation Planning and Programming

Traffic Analysis Section

(512)486-5136

Watch for Cyclists!

0 Kudos