I have a Point Feature Class with 2 million records with 35 fields. I have another csv file (contain 25 fields) which have around 4000 records to update certain records of the Point Feature Class . Within these 4000 records, only around 70 are matched with the common field which is the Account ID and among these records the fields are needed to be updated. There are more than 20 fields that will be needed to update. I am trying to automate this process of updating the fields of the match records.
Currently, I am trying to use write Python Script to update the fields. I am still very new to Python and have no programming background thus I am having problems with my script.
My workflow is this:
- Convert the csv file to Table in gdb
- Join (AddJoin) the Table to Point Feature Class.
Then, I am trying to use UpdateCursor which has failed ever since I tried.
If I am using ModelBuilder, I can use Field Calculator tools to change each of the field but I think it will take a long time and it does not seem to be a very nice way of updating the fields.
I am not sure if there is easier way of updating the fields in the Point Feature Class from the given csv files.