...
For instance, you have an import file with data from two different external systems. In it there are two number columns, now you can say basically: when column 1 has records import those, when empty choose column 2.
...
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 transformations 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 to 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.
...