Define transformations

The data pipeline wizard offers optional transformations that you define in the wizard or when editing a data pipeline. Transformations include:

• Filter columns: Deselect columns that you don't want to synchronize.
• Replace empty values: Define a value to populate in empty fields.
• Merge columns: Concatenate columns or fields that contain strings.
• Mask data: Conceal literal values to protect sensitive data while preserving schema integrity.

The transformation screens in the wizard and the editor display each selected table in a separate tab. The Filter columns and Merge columns screens preview up to four rows of values in each tab to help you decide what to transform.

After the tabs fill the available space, any additional tables are available from the More dropdown on the right:

As you navigate through the transformation screens, data previews update to show the selected transformations. If you make changes on one screen and navigate to another, the wizard or editor prompts you to refresh the preview. No data is actually transformed until AutoSync loads it to the target.