...
DataBridge supports transformations for import and export files. Data transformations can be added to import and export jobs.
Click here to view the article on Transformations for DataBridge Export.
After you select a transformation and go to the Configure Fields page in your DataBridge Profile you can easily see which columns the Transformation have been applied to. An icon has been added with a tooltip that shows all the transformations applied to the column, in the order in which they are applied.
How to
Create a new profile or edit an existing profile by clicking Manage profile. On the Transform page, select the Transformation you want and click Add.
...
The options to choose from are
Create a new field with the value of the selected field. When the value of that field is empty, the value of the fallback field will be used. | |
Add a new field with a fixed value. | |
Allows prepending and appending text to field values | |
Cleans a text field using a specific cleaning option. All cleaning options include white space, commas and periods. | |
Can be used for when you want one field from the source to map to multiple fields in the destination (for example: address which can be both visit and postal). | |
This transformation can be used to fill a field with the current date and time | |
Formats the value in the field. | |
| Map list | Converts each possible value of an input field into an item from a specific list in the destination. |
Merges the input fields into newly defined output fields. | |
Prevents the selected fields from appearing in the output. | |
Renames the title of the field and leaves the value unchanged. | |
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. | |
If the field matches the specified value the record will be skipped | |
Splits a field with a separator and adds a new field with the selected segment(s) You can find a detailed description of this transformation here |
...
In the example below, we have chosen the transformation 'Clean field' to clean the column with phone numbers. As clean option the Clean Number field is selected.convert a value with leading zeros and non-digits to a numeric value.
In the Configure Source page you can see the phone numbers and on the Configure Fields original value in the preview
In the Summary page you can see the result of the transformation, the nonthe leading zeros and non-digit characters are removed.
Copy field
The Address field from the Import file will also be used for the postal address. This can be achieved by choosing the Copy Field transformation.
...