FME Version
Files
Introduction
The task here is to take an Excel table of voting data and apply an expression to 4 of the attributes to change them from a total value to a percent value based on the number of total voters.
Excel Data Before Transformation
Excel Data After Transformation
In the ExpressionEvaluator, the @CurrentAttribute() function in FME 2015.0 or later is used to get the current value of the attributes chosen, apply the expression and replace them with the newly calculated value.
ExpressionEvaluator Settings
Other examples of using CurrentAttribute would be to:
- apply the same date/time format to several date/time attributes
- apply a math function like round() to several attributes
CurrentAttribute is also available in the AttributeConcatenator
Comments
0 comments
Please sign in to leave a comment.