+5FME Desktop 2022: “AttributeCreator” fails to copy a field into another using the arithmetic editor,
In the screenshot below, I wanted to copy the “fme_text_string” field to the “F1” but appears not work except for the first record.
What could be the issue here?
The data and workbench are attached
Best answer by dustin
Try using this expression into the AttributeValue.
@Evaluate((@ReplaceString(@Value(F1),",","")*2))
+31You shouldn't need an arithmetic calculation if you aren't making any changes to the fme_text_string value. Simply make the Attribute Value in the AttributeCreator = fme_text_string.
You can also do without the TestFilter by using the Conditional Values function in the AttributeCreator.
+5Thank you for the help.
I never figure it out why it fails when using arithmetic editor
+5
The issue is replicated as I wanted to multiply “F1” field with 2, for example. It just multiplies the first record and fails for other.
What could be the issue here?
+31Try using this expression into the AttributeValue.
@Evaluate((@ReplaceString(@Value(F1),",","")*2))
+5It works fine. However, as I applied it to another field, it fails as per the second screenshot
Is this code generic?
+19The code is generic for any attribute where you want to remove commas. But to remove "%", convert the number to its true value, and multiply by 2, try
@Evaluate((@ReplaceString(@Value(Percent_Legend),"%","")*0.02))
+5Thank you very much for the help. It works fine
