Script Map Replace Transformation

Overview

Data flow transformation performing find-and-replace transformation in specified input columns using dictionary object. Each key from the dictionary is searched in the input column and if found replaced with the related value.

Setup

The script has the following parameters:

• InputColumns - selects list of columns to be transformed.
• MapVariable - select variable containing mapping object. You can use the Dictionary Destination script to setup the object.
• CaseSensitive - indicates whether the search is case-sensitive.