How to update multiple field using field calculator from the joined the data

724
3
07-06-2021 11:53 AM
Labels (2)
VasanthKumar
New Contributor

I have a feature class and table, I joined the table with my feature class based on a common field and update all the fields in my feature class with the contents in the table using field calculator. I have 20 fields like name, study area,specialid, description etc in feature class. same field available in table also but it was a updated content so i need to add those in my feature class. every time I select each field one by one and do the field calculation. Doing 20 field take too much time to complete any automation available?

0 Kudos
3 Replies
DanPatterson
MVP Esteemed Contributor

You can script it, if you have the field calculations and the fields already.  Or you can use modelbuilder.

What have you tried or looked at (aka... script, model) beyond doing each field manually


... sort of retired...
VasanthKumar
New Contributor

i tried to create a script which using geopandas to read the feature class and table, while joining the data based on common field it gave error like objects and int can't be merged try pd.concat but i checked the object type for all, it same only.

0 Kudos
ABishop
MVP Regular Contributor

@VasanthKumar 
I agree with @DanPatterson .  I would build it all out in model builder using the geoprocessing tools built into ArcGIS Desktop or Pro... whichever you are using.  Then export the model to a python script and schedule it as a task.

Amanda Bishop, GISP
0 Kudos