Is there a direct relationship between the fields e.g. would something like eval *1=if(condition, *2, *1) make sense? If so, use foreach (it doesn't stop the multiple evaluations of the condition but at least you only have to write it once). Is this issue that the condition is complex and you don't want to evaluate it multiple times? If so, would something like eval set=if(complexcondition,1,0) eval A1=If(set=1,A2,A1) etc. make sense? Can you combine A1, B1, C1 into a multi-value field and A2, B2, C2 into another mv field and the assign one mv field to the other based on the condition?
... View more