Joining Layers in ArcGISPro

97
8
10-03-2018 10:48 AM
Highlighted
New Contributor III

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??

Reply
0 Kudos
8 Replies
Highlighted
Esri Regular Contributor

Hi Michelle,

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

Thanks,

--Rich

Reply
0 Kudos
Highlighted
New Contributor III

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!

Reply
0 Kudos
Highlighted
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

Reply
0 Kudos
Highlighted
New Contributor III

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!

Reply
0 Kudos
Highlighted
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.

Reply
0 Kudos
Highlighted
New Contributor III

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!

Reply
0 Kudos
Highlighted
Esteemed Contributor

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

Reply
0 Kudos
Highlighted
New Contributor III

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!

Reply
0 Kudos