Python/VB scripts that pass in attribute values from joined excel tables

JesseBellora — Thu, 16 Oct 2014 16:24:33 GMT

Hi all,

To my knowledge you can not run a field calculation on fields that are from joined excel tables. This was based off of what I could gather from the web, and that when I try to field calculate on those fields it is simply grayed out.

So I have a field in my feature class (Let's say it is called " Field_FeatureClass " ) I am hoping I can field calculate using VB or Python scripts (If/else statements, etc.). I want to take in the corresponding cell value from the field belonging to the joined excel table (We will say it's called " Field_Excel " ) and translate that into a variable to use in an expression to then populate the corresponding cell in the field Field_FeatureClass.

I've had no luck thus far and I don't know if it's the way I'm setting up my expressions/statements, or if you simply can not pass in variables from a joined excel table to use in a field calculation/expression.

Thanks

topic Python/VB scripts that pass in attribute values from joined excel tables in Python Questions

Python/VB scripts that pass in attribute values from joined excel tables