Hi 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.
Try 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.
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.
Try 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.
Try 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.
Try 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.
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.
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 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).