This function substitutes values using mapping table. The mapping table can be populated manually or loaded from file/database.
Properties
Manually populating Mapping table
Populating Mapping table using database/file
Special Note for text files: it is extremely important to specify a correct Line terminator otherwise the application may hang when working with very large text files
Once the file format is defined it is important to define the mapping for input and output fields.
To change Transformation function properties double click on it