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:
Column1 | Column2 |
1 |
2 |
1 |
3 |
1 |
4 |
By selecting Column1 for GroupColumn, Column2 for JoinColumn and ; for JoinSymbol you will get the following output row:
Column1 | Column2 |
1 |
2;3;4 |
Related technology
- To do the reverse transformation, check Split Column Transformation script.
Configuration
To use this script, you would need to load it in COZYROC JavaScript Component. If you are using COZYROC SSIS+ 2.0 or later, after selecting the corresponding script type and opening the component editor, you can select the script from a dropdown list with the pre-built scripts. For COZYROC SSIS+ 1.9, you can download the JavaScript file and browse to it via the "Import JavaScript code" button.

Knowledge Base
COZYROC SSIS+ Components Suite is free for testing in your development environment.
A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud.