Apply One Expression to Many Attributes | ExpressionEvaluator

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