...
Add conditional field | 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 field | Add a new field with a fixed value. |
Append text value | Allows prepending and appending text to field values |
Clean numberfieldClean | Cleans a text field that contains a number. Removes using a specific cleaning option. All cleaning options include white space, commas and periods. |
Copy field | 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). |
Current date time | This transformation can be used to fill a field with the current date and time |
Format text value | Formats the value in the field. |
Merge fields | Merges the input fields into newly defined output fields. |
Remove fields | Prevents the selected fields from appearing in the output. |
Rename field | Renames the title of the field and leaves the value unchanged. |
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. |
Skip | If the field matches the specified value the record will be skipped |
Split field | 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 |
...
The “Append text value” transformation allows for prepending and appending text to field values.
Clean
...
field
In the example below, we have chosen the transformation 'Clean numberfield' to clean the column with phone numbers. As clean option the Clean Number field is selected.
In the Configure Source page you can see the phone numbers and on the Configure Fields page you can see the result of the transformation, the 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.
...