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
