General Data for Data Migration/Conversion Lists

[About]

Usage

Use this window to add new 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