Problem
When referring a string column in a formula, and the value of the string column is composed of numbers, starting with a '0', the value is interpreted as a number.Consider following configuration
... col.domainref = Domain Reference col.domainref.type = string ... col.genref = MRM Reference col.genref.type = string col.genref.formula = {domainref}
When the content of domainref is for instance 010, the value of the genref column will be 10. The string value 010 is interpreted as a number 10. The column genref will therefore contain the string 10.
Workaround
Provide a hint to the formula parser that the dependent column value should not be interpreted as a number as follows
... col.domainref = Domain Reference col.domainref.type = string ... col.genref = MRM Reference col.genref.type = string col.genref.formula = "" + {domainref}