Create a Layer with Join

[DRae]

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

[BrandonMcAlister · Accepted solution]

@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  

[DRae]

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

[EvanMyers1]

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.

[DRae]

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

[BrandonMcAlister · Accepted solution]

@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 

[Laura]

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.