...
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 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 |
...
We have chosen the format 'Upper Case' for the Company field. And this is the result in the Configure fields.
Map list
Converts each possible value of an input field into an item from a specific list in the destination. This transformation is an enhancement for the Replace transformation so you do not have to use multiple Replace tansformations anymore.
In this example below we want to convert the values in the Country column of the import file.
| Field | Select the field you want to use. In this example Country |
| Output field name | You can name the output field. In this example we choose Country name as output field |
| Destination list | Choose the list which values must be assigned to each input value. You can choose not select a value and fill in your own values in the list mapping |
| List mapping | Assign an output value to each input value. In this example we choose the country from the SuperOffice Country list Note: Only the first 15 unique records from the import file will be shown. You can add more manually with the Add button |
| Copy unknown value to output field | Select this option if the field contains a value that is not assigned and it should be copied to the output field. If not, the output field will be left blank |
In the Configure fields page we can now map this new field.
Merge fields
In this example, the fields Address and Number will be merged into a new output field Street address. As a delimiter, a space is used.
...