I need to find an easy way to update multiple values in a file geodatabase attribute table. These same values will need to be found in the table and replaced with values that I have within a list on a monthly basis so I would very much like to make this an automated function.
Is this possible?
My abilities are not quite there yet when it comes to programming so any assistance or guidance someone can provide would be extremely valuable.
Thank you in advance.
How many attribute tables, and how many values do you need to update on a monthly basis? There's a find and replace tool which you can use if it's only a few values in a limited number of tables:
If you want something more automated, here's what I'd do:
That sounds like it will increase your productivity and so would be a good first forray into arcpy.
Thank you for replying to my message.
Typically it will be just one attribute table that will require edits. The number of fields that will require records to be modified will range from just 1 to 2. Not that many.
The number of values to update on a monthly basis is an additive process. It may start out with 3 values to change, but then the following month the same 3 values will still need to be changed and perhaps 4 more to add to the list. The list will grow as we move along with some dropping off and others being added to the process.
Thank you for the automation suggestion. I will definitely look into it. Hopefully the learning curve isn't too steep.