I have adapted a python dictionary from here to join and calculate a field between a feature class and a lookup table while concatenating on the fly.
Is it possible to ignore a field while concatenating and still calculate a value in?
ie. I am concatenating on the fly using a python dictionary using field [Main_Type], [Material], and [Diameter] in my feature class. In my lookup table that becomes a python dictionary I have the same fields but for each Main_Type and Diameter I leave a blank Diameter field with a lookup cost. I want to concatenate/field calculate the cost from the lookup to the feature class and if the Diameter field does not match, then match based on the Main_Type and Material only.
Any help would be appreciated!