splitting of a row into multiple rows
Posted: Mon Jan 28, 2008 5:02 am
Hi,
My i/p file has 3 columns.Say Order no,Order Name.Order Location.
The O/p File has two fields Order No,Order Location code
I/P-
100,A,ABC
200,B,XYZ
300,C,MNO
O/P-
100,10
200,20
200,20
200,20
300,30
300,30
That means depending upon Location name the I/p gets split into multiple records.
When Location name=XYZ the o/p becomes 3
When Location Name=MNO the o/p is 2
Please suggest which stage to use to split the records depending on the condition
Thanks in advance
Shaonli
My i/p file has 3 columns.Say Order no,Order Name.Order Location.
The O/p File has two fields Order No,Order Location code
I/P-
100,A,ABC
200,B,XYZ
300,C,MNO
O/P-
100,10
200,20
200,20
200,20
300,30
300,30
That means depending upon Location name the I/p gets split into multiple records.
When Location name=XYZ the o/p becomes 3
When Location Name=MNO the o/p is 2
Please suggest which stage to use to split the records depending on the condition
Thanks in advance
Shaonli