AnsweredAssumed Answered

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

Question asked by TooManyUsernames on Oct 16, 2014

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

Outcomes