Is there a way to mass update/merge records with similar naming conventions?

[-_Ashley-B-Potter_-]

I am having to do some migration clean up with some of the records that were generated when we migrated back in December. There are roughly 70,234 records that are tied to various subdivisions that need to be consolidated based on the subdivision name. Is there a way to easily do this instead of one sub at a time? I have tried to narrow everything down by definition queries, removing pin numbers, etc. but I get locked up or the data disappears. I also would like to be able to mass updated the record type.  

Here is an example of two separate sub records:

Current (Not merged)

End result (Merged)

[JasonCamerano]

Hello @-_Ashley-B-Potter_- 

Hopefully I'm understanding your question correctly.  You have a bunch of records that have features in them and you want to consolidate all those features into one record. 

Here's what I would suggest. 

1. Create the new record that you want everything to be associated to.
2. Set that record as Active
3. Open Manage Records and search for the records that have the features you want to move over to the newly created one
4. In the manage records pane select all the records and then right click and choose Select Features in Records (use shift click to multi select)
   
5. Now all the polygons, lines and points from all those records will be selected.
6. Go to the records HUD and click the menu button and choose "Assign Selection To Record"
   
7. Those features will now all be assigned to your newly created record. 
8. You can now clean up those empty records by deleting them as necessary. 

Let me know if this workflow accomplishes what you need. 

- Jason Camerano

[-_Ashley-B-Potter_-]

Thanks, Jason for your response. I guess I was hoping there would be a faster way to accomplish this task. I am only able to work on it part-time. 

[AmirBar-Maor]

And here is another idea, assuming I understand it right 🙂

The good thing about records is that they are a simple feature class and you can edit any attribute you want.

From my understanding, the records were not created correctly and you want to recreate them. In that case the steps would be:

1. Open the Attribute table and select all the record features
2. Delete them
3. Save edits
4. Run the geoprocessing tool Create Parcel Records. You can use an expression if you want to refine the resulting record name.

But... you probably already created some records since the migration in December that you want to keep. In that case:

1. Make sure to only select the records that were created during data migration. You can use the editor tracking field for that.
2. Likewise, for the input parcel features for the geoprocessing tool Create Parcel Records - select the features that were created in December. You can use the editor tracking field for that.

You can batch-update the record type in the attribute table. Select the records you want to update and use the Calculate field to update them. You can even temporarily join the records table to another table if you need to.

Hopefully one of these answers helps you and others in the community

[-_Ashley-B-Potter_-]

Thank you, for your response. I will test this out. I have tried to batch-update the record type in the past, however, I will crash or lock up. Any recommendations to why that might occur?