Script Split Column Transformation

Overview

Data flow transformation, which can split a row based on column value into multiple data flow rows.

Setup

The script has the following parameters:

SplitColumn - selects column containing value to be split.
SplitSymbol - specifies split symbol. It can be regular expression.

Sample

If you have the following input row:

Column1	Column2	Column3
1	2;3;4	5

By selecting Column2 for SplitColumn and ; for SplitSymbol you will get the following output rows:

Column1	Column2	Column3
1	2	5
1	3	5
1	4	5

Related technology

To do the reverse transformation, check Join 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.

Split_Column_Transformation.js

SSIS+ Components Suite

SSIS NoW

Excel Add-in for SAS

Overview

Setup

Sample

Related technology

Configuration

Knowledge Base

Newsletter

Contact Us

Follow Us

Support