Transformations for DataBridge export

Last update:
Created :
Written by Thomas Speekenbrink

Overview:

DataBridge supports transformations for import and export files. Data transformations can be added to import and exports. At the moment the following transformations are supplied: Rename field, Add field, Clean number, Merge fields, Replace, Format text value.
Click here to view the article on Transformations for DataBridge Import

How to:

Create a new profile or edit an existing profile by clicking Manage profile. Notice that you now have an extra step in the configuration wizard called Transform.

On the Transform page select the Transformation you want and click Add

TransformExport1.png

The options to choose from are:

   

Rename field

Renames the title of the field and leaves the value unchanged.

Add field

Add a new field with a fixed value.

Clean number

Clean a text field that contains a number. Removes all non-digit characters, including white space and comma's and periods.

Merge fields

Merges the input fields into a newly defined output fields.

Replace

If the field matches the specified value it will be replaced by a new value. For example: if the input value is 'OK' it can be replaced by 'TRUE' and used to turn interests on.

Format text value

Formats the value in the field.


The added transformations can be edited or removed at any time, see below.

TransformExport5.5.png

 

THE OUTPUT RESULTS
The Results of the Transforms can be seen in the Summary page of the Export wizard. In the Field Configuration you can see the effect of the transformation on your Export data.

Below you can see the transformations Rename field, Clean number and Add field, which are used in this export.

TransformExport11.png

And this is the result on the Summary page. 

TransformExport6.png


OTHER OUTPUT RESULTS

Merge fields

In this example we will merge the first- and lastname in the Export file. The fields will be merged into a new field 'Name'. As a delimiter we use a space.

TransformExport6.png


The result can be see on the Summary page.

TransformExport8.png


Replace

In this example we will replace SuperOffice values. When they match, the values in the Interest column 'persint/Newsletter' will be replaced with the value OK. 

TransformExport9.png


On the Summary page you can see the result of the replace transformation.

TransformExport10.png


Format text value

With Format text value you can format the values in the chosen field. There are a couple of format options.
As an example let's use 'hello YouTube'

Upper case All in upper case HELLO YOUTUBE
Lower case All in lower case hello youtube
Capitalize first First letter in capital Hello YouTube
Capitalize first decapitalize rest First letter in capital, rest in lower case Hello youtube
Capitalize words First letter of each word in capital Hello YouTube
Capitalize words decapitalize rest First letter of each word in capital, rest in lower case Hello Youtube

TransformExport11.png


We have chosen the format 'Upper Case' for the Name field. And this is the result on the Summary page.

TransformExport12.png