Splitting Single Row into Multiple Rows Using ETL

Hi Guys ,

Here I have seen this is common scenario where we need to split the single rows into multiple rows as per their need.

So,I want to explain how to split the single row into multiple rows as mention below scenario:

For example:

Input:

ID	Col1	Col2	Col3	Col4
1001	Abc	Cde	12	34

Out Put:

ID	Col1	Col2
1001	Abc	12
1001	Cde	34

The above scenario you can achieved with the help of Row Normaliser step in ETL.

It’s very easy to use.

Etl design:

 Row Normaliser:

 OutPut:

 

If you have any question you can ask me or else you can drop me email :
 

Sumit Bansal

BI Developer