ArcGIS Pro Workflow Help: Creating a filtered shapefile copy with custom columns

[EthanT]

Hi everyone,

I am working with ArcGIS Pro and need help with a workflow involving shapefiles and attribute tables.

I currently have one shapefile, and I want to create a new copy of it with two specific changes:

1. Filter Rows: In the new copy, I do not want all the rows to appear—I only want a select subset of rows/features to be included and displayed on the map.

2. Add Columns: I want to add new columns (attribute fields) directly into this new copy of the shapefile.

I have already tried exporting the attribute table to Excel and using the Join feature, but that workflow did not give me the results I needed. These tables are thousands of lines so a way to mass edit would be needed (to easily perform VLOOKUP's and such to filter the rows).

Could someone explain the best step-by-step method or native tools in ArcGIS Pro to export only the selected rows into a new shapefile and add new columns to the resulting layer?

[DanPatterson]

Select Layer By Attribute (Data Management Tools) | ArcGIS Pro documentation unless you don't have a clean way of filtering out what you want.

If you already have a table with the columns that you want to add and a common field to use as the join field then use that field.  Otherwise, how do you intend to add the columns via a join? or are you looking at a way to calculate values for a field?

[EthanT]

I guess what I am asking is if there is a way to modify the data/table of a shapefile, such that I can easily delete multiple rows (not filter, it is not clean like that - to actually delete) and add column to it (the data in this column would also have to be entered through x lookups and the like), as join did not work for me

[DanPatterson]

perhaps you need to provide a sample table showing how you are selecting the rows to delete and the association of the columns you want to add relate to the remaining rows.

There are tools to delete rows and add fields and to then calculate values for those fields, but the data has to be placed in some row/column.  right now, it isn't clear whether, or how, the column values relate to the rows, and how do you intend to identify which rows to delete in the first place

[AlfredBaldenweck]

1) Select the rows you care about

2) Export the layer (right-click-> data-> export features)

3) In the new data, open the fields (right-click->data design-> fields)

4) Add and delete fields as necessary.

[Robert_LeClair]

The Export Features (Conversion Tools) | ArcGIS Pro documentation tool may be what you're looking for.  It has a filter parameter to select a subset of records and a fields parameter where you can add, delete, rename and reorder fields as well as other field properties.