Skip to content

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).