Translation

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

Introduction

Translating values in a table from one language to another is a way to enrich your data.

The Translation enrichment uses the translate custom script in the background. The Translation enrichment provides a user-friendly interface that helps you find which column contains the value to translate and select the languages involved.

Concept

Enriching your data means transforming and tailoring the data according to your needs. An enrichment is a set of instructions that you specify for Adverity to transform your data.

When you create an enrichment, you add it to the list of available enrichments in the workspace.

When you assign an enrichment to a datastream, each time data is fetched for the datastream, the data is transformed according to the enrichment. The enrichment only has an effect on datastreams to which you assign the enrichment.

Prerequisites

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

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

Translating data

To translate values in a column of your data table from one language to another, follow these steps:

  1. Select the workspace you work with in Adverity and then, in the platform navigation menu, click Enrichments.

  1. In the top right corner, click + Create Enrichment.

  2. Click Translation.

  3. (Optional) To assign the enrichment to individual datastreams of your choice, follow these steps:

    1. In the Assign to section, select Individual datastreams.

    2. In the drop-down menu, select the datastreams to assign the enrichment to them.

  4. (Optional) To assign the enrichment to all existing and new datastreams that belong to Datastream Types of your choice, follow these steps:

    1. In the Assign to section, select Datastreams Types.

    2. In the drop-down menu, select the Datastream Types to assign the enrichment to all datastreams that belong to these types.

    3. (Optional) In the Do not assign to these individual datastreams drop-down menu, select the individual datastreams that belong to the Datastream Types that you have selected, but you do not want to assign the enrichment to them.

  1. Click Next.

  1. Under the Instructions tab, in the Source column drop-down menu, select the field that contains the text in the source language.

  2. In the From language drop-down menu, select the source language. 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 target language.

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

  5. (Optional) By default, Adverity replaces the existing values in the field that contained the text in the source language. To preserve the original field and add the translated values to a new field, select Add additional column in the Action drop-down menu.

  6. (Optional) Click the Table Preview tab to display the impact of the instructions on the data extract. For more information, see Previewing enrichments.

  1. Click Next.

  1. (Optional) In Enrichment name, rename the enrichment.

  2. Click Create +.