Written by Thomas Speekenbrink
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
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
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.
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.
The Output results
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'
The result can be seen in the Configure Fields page.
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.
For our import we have chosen to add a field Code with a fixed value 123
The result can be seen in the Configure fields page