What fields can the CalculateField_management expression parameter contain? I mean the parameters can be the fields what are in the output table, or can they be a field of another table too?
There are two tables:
- lot of fields and a field, what needed to be placed to other table.
- The joined table. It contains the field what comes from the previous table and all of the records has unique value in that certain field.
Now the task is to go through on the table 2's certain field and compute other field in that table 2, but I need to search for values in table 1. If a record's "certain field's" value is the same as table 2's "certain field" value, then I need the other field datas from table 1 to compute table 2's other fields.
Does the expression parameters need to be from only one table or can I refer to other table fields too?
I hope it's understandable.