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 total number of voters.
Excel Data Before Transformation
Excel Data After Transformation
In the ExpressionEvaluator, the @CurrentAttribute() function is used to retrieve the current value of the selected attributes, 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