Transformations for DataBridge Import

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 three 3 transformations are supplied: Rename field, Add field, Clean number.
Click here to view the article on Transformations for DataBridge Export

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

Transform1.png

There are three options to choose from.

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

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

Transform5.png

 

NOTE: If you are adding transformations to an existing profile with mappings in place and choose to use the Rename field transformation you will see the message as shown in the picture below. 
This means that a mapping is no longer valid, due to the renaming.
This can easily be fixed by clicking the Remove Invalid Mapped Fields button and map the field to the correct field.

Transform6.png

 

The Output results

Rename fields

In the picture below you see the preview of a file with the column header 'Bedrijf'. With the transformation 'Rename field' we want to rename this column header from Dutch to English, to the column header 'Company'

Transform7.png

Transform3.png

 

The result can be seen in the Configure Fields page.

Transform8.png

 

Clean number

In the example below we have chosen the transformation 'Clean number' to clean the column with phone numbers. In the Configure Source page you can see the phone numbers and in the Configure Fields page you can see the result of the transformation, the non-digit characters are removed.

Transform12.png

 

Add field

For our import we have chosen to add a field Code with a fixed value 123

Transform13.png

 

The result can be seen in the Configure fields page

Transform14.png