---
title: "Select pre- and post-export transformations"
slug: "select-pre-and-post-export-transformations"
tags: ["Task", "Data Modeling Studio", "DMS"]
updated: 2026-03-20T08:19:48Z
published: 2026-03-20T17:44:45Z
canonical: "docs.staedean.com/select-pre-and-post-export-transformations"
---

> ## 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.

# Select pre- and post-export transformations

For each data model you can define transformations to be executed automatically before and after the data model is exported.

On data export for a data model, the processing transformations are used to do calculations in the target database. A processing transformation contains one or several SQL statements which define the transformation actions to be done.

You can have processing transformations executed before or after exporting data:

- **Pre-export transformations**: Used to do calculations on the metadata in the target database. For example, on enumerations or labels.
- **Post-export transformations**: Used to do calculations based on the data that is just exported to the target database.

### Steps

1. Go to **Data modeling studio > Data modeling studio > Data models**.
2. In the list, find and select the desired data model.
3. Click **Processing**.
4. Sub-task: Add several pre-export transformations at once.
  1. In the **Pre-processing** section, click **Add multiple**.
  2. In the list, find and select the desired transformations.

> [!NOTE]
> Note
> 
> Only the transformations of category '**Processing**' are shown in the list.
  3. Click **Ok**.
5. Sub-task: Add one pre-export transformation.
  1. In the **Pre-processing** section, click **Add**.
  2. In the **Template** field, enter or select a value.

> [!NOTE]
> Note
> 
> Only the transformations of category '**Processing**' are shown in the lookup.
6. Sub-task: Add several post-export transformations at once.
  1. In the **Post-processing** section, click **Add** multiple.
  2. In the list, find and select the desired transformations.

> [!NOTE]
> Note
> 
> Only the transformations of category '**Processing**' are shown in the list.
  3. Click **Ok**.
7. Sub-task: Add one post-export transformation.
  1. In the **Post-processing** section. click **Add**.
  2. In the **Template** field, enter or select a value.

> [!NOTE]
> Note
> 
> Only the transformations of category '**Processing**' are shown in the lookup.
8. Sub-task: Define sequence of pre- and post- export transformations.
  1. Define the sequence in which the pre- and post-export transformations are applied.

To move a transformation one position up, in the **Pre-processing** section or **Post-processing** section, select a transformation, and click **Up**.

> [!NOTE]
> Note
> 
> You can also manually set the sequence in the **Order** field.
  2. To move a transformation one position up, in the **Pre-processing** section or **Post-processing** section, select a transformation, and click **Down**.

> [!NOTE]
> Note
> 
> You can also manually set the sequence in the **Order** field.
9. Click **OK**.
10. Close the page.

> [!NOTE]
> Notes
> 
> You can apply transformations without exporting the data model. To do so, on the Select processing dialog, to apply:
> 
> - A selection of pre-export transformations, in the **Pre-processing** section, select the transformations, and click **Apply** selected.
> - All defined pre-export transformations, in the **Pre-processing** section, click **Apply** all.
> - A selection of post-export transformations, in the **Post-processing** section, select the transformations, and click **Apply** selected.
> - All defined post-export transformations, in the **Post-processing** section, click **Apply** all.

## Related

- [Process data export](/process-data-export.md)