# Apply To All Transformation

An ApplyToAll Transformation applies an Expression Transformation to all mapped elements. This transformation is useful when applying a common Expression Transformation to all data without the need to build multiple Expression Transformations.

## **Steps**

To use an ApplyToAll transformation, drag and drop the *ApplyToAll* from the *Transform* Group in the Flow toolbox to the flow designer.

![](https://627607815-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6xzBT0roYJkfVS5klkLl%2Fuploads%2Fr9Ao2Exjxek8zyYyhCk4%2F0.png?alt=media)

Map all the data to the *ApplyToAll* transformation created on the flow designer. These are all the data that a common expression will be applied to.

The properties window is also where the expression to be applied is specified. A parameter called *$FieldValue* will be available for an expression to be applied to. This will represent all of the data that was mapped to the ApplyToAll transformation.

## **Sample**

In this example, we are going to apply an Expression transformation to two string fields to convert them into lowercase values.

![](https://627607815-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6xzBT0roYJkfVS5klkLl%2Fuploads%2FFonraKW5QmX7OT1ugRjU%2F1.png?alt=media)

The properties for ApplyToAll will give you the option to add an expression to a *$FieldValue* parameter. This will apply the expression to all of the mapped elements on the transformation.

![](https://627607815-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2F6xzBT0roYJkfVS5klkLl%2Fuploads%2FpsBYtLpXYT3l36pdV5Vg%2F2.png?alt=media)

The *ApplyToAll* transformation takes the *MaritalStatus* and *Gender* field parameters and transforms them into lowercase values.