Folks,
This should be simple but I'm just not finding the answer.
Using an AttributeManager I want to add a value "0.09" to all the existing values in a column of data from a Mapinfo table during translation amongst other things.
The Column is "Average" and is a defined Decimal type field.
The syntax I'm using is clearly wrong.
@Value(Average)+0.09
returns -9999.00 for all values.
What am I doing wrong?
Thanks in advance
Andrew
Best answer by takashi
You have to enter a math expression with the Arithmetic Editor. You can open the editor from the menu command "Open Arithmetic Editor" under the menu button in the parameter field.
If you connect an Inspecter transformer to the output port of the AttributeManager and run the workspace, what result would appear on the Table View in FME Data Inspector?
If you connect an Inspecter transformer to the output port of the AttributeManager and run the workspace, what result would appear on the Table View in FME Data Inspector?
Yes there is an error
Attribute Average of type decimal has an illegal value of '57.41+0.09'. Value is set to -9999 You have to enter a math expression with the Arithmetic Editor. You can open the editor from the menu command "Open Arithmetic Editor" under the menu button in the parameter field.
You have to enter a math expression with the Arithmetic Editor. You can open the editor from the menu command "Open Arithmetic Editor" under the menu button in the parameter field.
@Evaluate(@Value(Average)+0.09)
+44You have to enter a math expression with the Arithmetic Editor. You can open the editor from the menu command "Open Arithmetic Editor" under the menu button in the parameter field.
