+1Hi there, Anyone could help? I would like to build a FME workbench to run a multiplication for all the value if they are belongs to the same name. Attached a sample data e.g. I want to get the multiplication for armstrong_2006( 42*10*39*26), then I want the result to be added back in this spreadsheet. thanks.
Best answer by dustin
Use an Aggregator with the following settings:
In an AttributeCreator, create a ‘result’ field with the expression @Evaluate(@Value(value)). This will multiply the value because we used * as the separator.
Finally, use a FeatureMerger with Requestor and Supplier both set to the ‘name’ field.
Hi Dustin, can I have a similar question to this? if the value are texts (A,B,C) how do I combine them into 1 row with separator of “,”? thanks
Use a comma as the Separator Character in the Aggregator, then in the AttributeCreator instead of @Evaluate(@Value(value)), use @Value(value).
+59Try the Aggregator transformer. Group-by on the name and use the Attribute to Sum parameter to pick the data field. The output will be one record per name with the sum of the values.
+31Use an Aggregator with the following settings:
In an AttributeCreator, create a ‘result’ field with the expression @Evaluate(@Value(value)). This will multiply the value because we used * as the separator.
Finally, use a FeatureMerger with Requestor and Supplier both set to the ‘name’ field.
+59Try the Aggregator transformer. Group-by on the name and use the Attribute to Sum parameter to pick the data field. The output will be one record per name with the sum of the values.
Sorry. You wanted multiplying, not addition. My bad.
+1Dustin, excellent.👍 I tried the workflow that you provided, it worked for me very well. Much appreciated.
+1Try the Aggregator transformer. Group-by on the name and use the Attribute to Sum parameter to pick the data field. The output will be one record per name with the sum of the values.
Sorry. You wanted multiplying, not addition. My bad.
no problem at all. thanks for your answer as well.
+1Try the Aggregator transformer. Group-by on the name and use the Attribute to Sum parameter to pick the data field. The output will be one record per name with the sum of the values.
Sorry. You wanted multiplying, not addition. My bad.
Dustin, excellent.👍 I tried the workflow that you provided, it worked for me very well. Much appreciated.
+1Use an Aggregator with the following settings:
In an AttributeCreator, create a ‘result’ field with the expression @Evaluate(@Value(value)). This will multiply the value because we used * as the separator.
Finally, use a FeatureMerger with Requestor and Supplier both set to the ‘name’ field.
+1Use an Aggregator with the following settings:
In an AttributeCreator, create a ‘result’ field with the expression @Evaluate(@Value(value)). This will multiply the value because we used * as the separator.
Finally, use a FeatureMerger with Requestor and Supplier both set to the ‘name’ field.
Hi Dustin, can I have a similar question to this? if the value are texts (A,B,C) how do I combine them into 1 row with separator of “,”? thanks
+31Use an Aggregator with the following settings:
In an AttributeCreator, create a ‘result’ field with the expression @Evaluate(@Value(value)). This will multiply the value because we used * as the separator.
Finally, use a FeatureMerger with Requestor and Supplier both set to the ‘name’ field.
Hi Dustin, can I have a similar question to this? if the value are texts (A,B,C) how do I combine them into 1 row with separator of “,”? thanks
Use a comma as the Separator Character in the Aggregator, then in the AttributeCreator instead of @Evaluate(@Value(value)), use @Value(value).
