...
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 field | Add a new field with a fixed value. |
Append text value | Allows prepending and appending text to field values |
Clean field | Cleans a text field 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. |
| Map list | Converts each possible value of an input field into an item from a specific list in the destination. |
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 |
...