Script Join Column Transformation

Overview

Data flow transformation, which can combine multiple rows based on grouping column into single data flow row.

Setup

The script has the following parameters:

• GroupColumn - selects input grouping column.
• JoinColumn - selects input join column.
• JoinSymbol - specifies join symbol. It can be regular expression.

Sample

If you have the following input rows:

By selecting Column1 for GroupColumn, Column2 for JoinColumn and ; for JoinSymbol you will get the following output row:

Related technology

• To do the reverse transformation, check Split Column Transformation script.