Joining Layers in ArcGISPro

[MichelleCouden]

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

[RichRuh]

Hi Michelle,

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

Thanks,

--Rich

[MichelleCouden]

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!

[RichRuh]

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

[MichelleCouden]

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!

[RichRuh]

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.

[MichelleCouden]

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!

[MichaelVolz]

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

[MichelleCouden]

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!