topic Re: Create a Layer with Join in ArcGIS Pro Questions

Create a Layer with Join

DRae — Thu, 29 Aug 2024 15:05:41 GMT

I want to create a new layer that base on the existing feature class, and need to join with other table to display more information. How can I do it in ArcGIS Pro. I know how to create a new layer with adding data or drag the feature class from the databases to the map to create the new layer. Can anyone give me an advise on it

Re: Create a Layer with Join

BrandonMcAlister — Thu, 29 Aug 2024 15:21:51 GMT

@DRae

So you have an existing feature class with information already in the attribute table? Then you have a table you want to add to the existing feature class right?

You want to join the table to the existing feature class, so the feature class and the table need to have a common field with unique identifiers to join off of. This is done with the join table tool, add the feature class and table to the map. Then in the contact pane on the left side of the screen right click he feature class and select Join and Relates > Add Join.

Select the Feature class first, then select the table you want to join. Use the drop down menus to select the field you will be joining off of. After that is done validate the join to check for how many 1to1 matches there will be and how many 1 to many joins there will be. If satisfied run click run.

After it is joined check you attribute table to verify results then export the feature class to a new feature class to save the join to the attribute table.

Add join

https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/add-join.htm

Export Data

https://pro.arcgis.com/en/pro-app/latest/help/data/geodatabases/overview/export-data.htm

Re: Create a Layer with Join

DRae — Thu, 29 Aug 2024 15:42:34 GMT

Thank Brandon,

I read the add join doc, but it said that the output will be "Updated Input Layer or Table View". I didn't click the Run yet because I want a new layer instead of update the input layer

Re: Create a Layer with Join

EvanMyers1 — Thu, 29 Aug 2024 17:28:03 GMT

A Join is not permanent and does not add to the original data, it is simply visual. If you want it to be permanent, you can perform the join, then export the feature layer as a new.

Orrr you can run "Join Field" geoprocessing tool, this will permanently affect your existing table and will not create a new feature.

Re: Create a Layer with Join

DRae — Thu, 29 Aug 2024 17:55:58 GMT

I got the error 9999 said that the table is lock when I execute the add join

Re: Create a Layer with Join

BrandonMcAlister — Thu, 29 Aug 2024 18:16:20 GMT

@DRae

A lock can mean several thing, like the table is being edited, the table is part of a database that does not allow editing, or someone else has the table open in their version of Arc Pro or Arc Map.

If you simply want to add information to the table and make your own feature layer then export the original feature class to a geodatabase of your choosing then use the method I described or use the join field tool @EvanMyers1 mentioned.

Join Field

https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/join-field.htm

Re: Create a Layer with Join

Laura — Tue, 03 Sep 2024 21:24:01 GMT

To get rid of locks you can right click the layer in the database, go to locks and click the connections tab. From there you can highlight everyone and choose disconnect. However these locks mean they are actively connected to your database/layers. I would perform this at the end of the day after everyone leaves to ensure there is no active editing that you can mess up.