Data Migration Conversion Lists¶
The conversion lists are used to change column values from an old value to a new value during the execution of a job. Conversion lists are connected to columns defined on migration jobs in Migration Job/File Mapping or Migration Job/Source Mapping.
Example:
| Old Value | New Value | Comment |
|---|---|---|
| 4370 | AH | All values '4370' will be converted to 'AH' |
| 42% | AC | All values starting with '42' will be converted to 'AC' |
| 4% | All remaining values starting with '4' will be converted to blank (NULL-VALUE) | |
| % | AB | Remaining occurrences will be converted to 'AB'. If this line is omitted, remaining occurrences will keep their original value |
| % | All remaining values will be returned blank. This is very useful if this is a mandatory column, and your list should cover all possible combinations. Then you will get an error-message if you have missed out anything. |
Conversions Lists are automatically included in export files (when you execute FNDMIG_EXPORT).