--- title: "Set up transformation" slug: "set-up-transformation" description: "Learn how to set up value, conditional, and range transformations to effectively change source values in your integration design process." tags: ["Task topic"] status: "update" updated: 2026-10-05T12:03:49Z published: 2026-10-05T12:03:49Z canonical: "docs.staedean.com/set-up-transformation" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.staedean.com/llms.txt > Use this file to discover all available pages before exploring further. # Set up transformation If you need a transformation and it does not already exist, you must set it up. You can use a transformation to change a source value into another value. You can use these types of transformations: - **Value**: A standard transformation to directly transform a source value into another value. You have these options: - **Value**: The source value is always transformed to another value. - **Condition**: The source value is only transformed to another value if a condition is met. The condition is based on a table field that is defined for the source document record. So, the condition record field must be available in the source document, but it is not required in the message field mapping. Usually, the condition record field is not the field for which you define the transformation in the field mapping. - **Range**: A transformation that is based on a range. All values that meet the range are transformed to the defined Value to. **Example:** Range='EN-*' and Value to= 'EN-US'. All values that start with 'EN-' are transformed to 'EN-US'. Usually, you use either value transformations or range transformations. However, if you use a combination, first the value transformations are checked for an applicable transformation and then the range transformations. The first found applicable transformation is applied. ### Steps 1. Click **Connectivity studio - Integration Design**. 2. Click **Transformations**. 3. Click **New**. 4. In the **Transformation** field, type a value. 5. In the **Project** field, enter or select a value. 6. To get an error message when a value cannot be transformed, make the transformation mandatory. Select **Yes** in the **Mandatory** field. 7. Sub-task: Set up a value transformation. 1. Click **New**. 2. In the **Value from** field, type a value. 3. In the **Value to** field, type a value. 4. You can make a value transformation company-specific, so you can reuse the transformation in several companies. In the **Company accounts ID** field, enter or select a value. 8. Sub-task: Set up a conditional value transformation. 1. Click **New**. 2. In the **Transformation element** field, select '**Condition**'. 3. In the **Value from** field, type a value. 4. In the **Value to** field, type a value. 5. You can make a value transformation company-specific, so you can define several value transformations, each for a different company. When a transformation is applicable, first a value transformation is searched for the applicable company. If this transformation does not exist, a transformation is searched for without a company defined. If this transformation also does not exist, no transformation is applied. In the **Company accounts ID** field, enter or select a value. 6. In the **Record** **table** field, enter or select a value. 7. In the **Record** **field** field, enter or select a value. 8. Sometimes, you want to skip a value transformation when running a message. You can use conditions to indicate if the value transformation must be applied. The value transformation is only applied if the condition is met. Examples of values that you can use to define a condition: In the **Condition** field, enter or select a value. - ..Item1 (Item1 and smaller) - Item1.. (Item1 and greater) - Item1,item5..item10 (Item1 or item5 to item10) - Item1,item2 (Item1 or item2) - !123 (Not 123) - “” (Empty) - !”” (Not empty) 9. Sub-task: Set up a range transformation. 1. Expand the **Range** section. 2. You can apply a type conversion before you apply a range transformation. As a result, the source value is first converted to another type. The resulting value is used to find the applicable range transformation. In the **Type conversions** field, enter or select a value. 3. Click **New**. 4. In the **Range** field, type a value. 5. In the **Value to** field, type a value. 6. You can set up a company-specific range transformation. A company-specific range transformation is applied: In the **Company accounts ID** field, enter or select a value. - Only in the defined company. - Before range transformation without a company defined. 10. Sub-task: Test transformation. 1. Expand the **Test value** section. 2. In the **Value from** field, type a value. 3. If you use conditions in the value transformations, you can enter a record table for testing purposes. In the **Record** **table** field, enter or select a value. 4. Click **Test**. 11. Close the page. > [!NOTE] > **Note** > > You can change the type of an existing value transformation. If you do so, also fill in the applicable fields.