ckesler_egi

Calculate multiple feature class fields from stand alone table

Discussion created by ckesler_egi on Jun 1, 2011
Latest reply on Jun 5, 2011 by kimo
Greetings,

I have two feature classes and four tables stored in a file based geodatabase that periodically need attributes recalculated based on data stored in and Excel spreadsheet.  Any ideas on how to establish a Join then Calculate the attributes based on columns in Excel using Python?
The Joins would all be 1 to 1.
The calculations are simple, ie.
OilField_Locations.FIELD_ID = !OilFields$.FIELD_ID! (calculate fc field = column in Excel)
but I have around 250 fields to calculate and do not have any desire to go through them manually.

Thanks!

Outcomes