DEPRECATED: Starting with SSIS+ 1.9, the .NET scripts are no longer maintained. Use the provided JavaScript alternative scripts instead.
Script File:
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.
Requirements
Depends on COZYROC Script Component Plus for implementing parameters user interface.
Requires installation of COZYROC SSIS+ 1.4 library.
Sample
If you have the following input rows:
| Column1 | Column2 | Column3 |
|---|---|---|
| 1 | 2 | 5 |
| 1 | 3 | 5 |
| 1 | 4 | 5 |
By selecting Column1 for GroupColumn, Column2 for JoinColumn and ; for JoinSymbol you will get the following output row:
| Column1 | Column2 | Column3 |
|---|---|---|
| 1 | 2;3;4 | 5 |
Related technology
- To do the reverse transformation, check Split Column Transformation script.