The Expression transformation calculates values within a single row. Use the Expression transformation to perform non-aggregate calculations.
For example, you might use an Expression transformation to adjust bonus percentages or to concatenate first and last names.
When you configure an Expression transformation, create an expression field for the output of each calculation that you want to use in the data flow. Create a variable field for calculations that you want to use within the transformation.