Creating transformation rules involves uploading a sample of the file that will be transformed and then defining the rules according to which the data will be modified. Such transformation rules can be reused in workflows by means of the [Data Transformation node](/docs/automation/operation/data-transformation-node). This way you may create workflows that retrieve data from external sources, modify them, and process them further.

1. Go to

**Automation Hub > Transformations > Create transformation**. 2. Enter the name of the transformation. ## Select a goal --- Before you proceed with selecting sample data and defining transformation rules, optionally you can [select a goal](/docs/automation/data-transformation-and-imports/creating-data-transformation#select-a-goal) to help you structure the data. Your goal may be to an import of transactions, events, or profiles into Synerise (called **standard goals**). When you select one of the standard goals, you will see a list of columns with their names which are required as the output of the selected transformation. The system will automatically check which columns you included and inform you if some are missing. If you want to create a transformation diagram without a specific goal and you know the structure of the output data, skip this step. 1. On the dashboard, on the upper right corner, click **Add goal**. 2. On the left pane, select a goal: - **Import profiles** - **Import transactions** - **Import vouchers** - **Import events** - **Import promotions** 3. On the right pane, expand the list of required columns the output data must contain. 3. Click **Apply**. ## Create a rule diagram --- 1. Upload a file with the sample data. We recommend selecting a file that contains a sample of data you use.

You can read more about the configuration of [Data Input here](/docs/automation/data-transformation-and-imports/transformations-and-data-operators/data-input).

5. Add subsequent nodes by clicking the right mouse button. The full documentation on the nodes available for data transformation is available [here](/docs/automation/data-transformation-and-imports/transformations-and-data-operators). 6. As the final node, add [Data Output](/docs/automation/data-transformation-and-imports/transformations-and-data-operators/data-output) in which you will see the final result of file modifications. 7. Connect the nodes with each other. 12. Saving the transformation: - If you want to save it as a draft, click **Save**. - If you want to save it and make it available in Automations, click **Save and publish**. **Example result**:

## What's next --- You can add a [Data Transformation node](/docs/automation/operation/data-transformation-node) with this transformation while preparing the [workflow](/docs/automation/actions/synerise-integrations#example-with-transformation) that includes transforming the source file.

Selection of transformations in Data Transformation node