Configuring a Merge Strategy
To configure a merge strategy, edit the settings in the Strategies view of a Merge transformation.
1. Select the Strategies view.
2. Click New.
The New Strategy wizard opens.
3. Click the Inputs field to select input ports for the strategy.
4. To define the merge character to place between merged items, click Choose. If you do not select a merge character, the Merge transformation uses a space character by default.
5. Optionally, select Include empty strings in merged output to include empty input strings in the output.
6. Click Finish.