Translation

This guide explains how to use the Translation transformation to translate values in your data table from one language to another.

Introduction

Use the Translation transformation to translate your data from one language into another. The Translation transformation provides a user-friendly interface that helps you to select the column that contains the value to translate and select the languages involved. The Translationtransformation uses the translatecustom script instruction in the background.

This video guide explains how to create and configure a Translation transformation.

Prerequisites

Before you complete the procedure in this guide, perform all of the following actions:

• Create a datastream.

• Apply the correct Data Mapping to your datastream.

• Fetch data for the datastream.

• Make sure that the data extract fetched from the datastream contains a field with text in the source language that you want to translate to the target language.

Configuring the Translation transformation

This guide explains how to configure the Translation transformation. Before completing this step, start creating a transformation by following the instructions in Using standard transformations. To configure this transformation, follow these steps:

1. In the Source column drop-down menu, select the column that contains the text in the source language.

2. In the From language drop-down menu, select the language of the text in the source column. If you do not know the source language or the text is in more than one language, select Automatic.

3. In the To language drop-down menu, select the language that you want to translate the text into.

4. In the Translation service provider drop-down menu, select a translation service provider.

5. In the Action drop-down menu, choose what to do with the translated text:

   • Choose Replace existing values to replace the text in the source column with the translated text.

   • Choose Add additional column to add a new column to your data extract containing the translated text. The new column is added as the rightmost column in your data extract and named [original column name]_[target language].