Combine Records Stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
Grace J.
Participant
Posts: 22
Joined: Mon Nov 03, 2008 5:34 am

Combine Records Stage

Post by Grace J. »

Hi All, I need a help for the following logic for working with Restructure stages...
My input is
col1,col2,col3
1,A,12
1,B,13
1,C,14
2,D,15

In the Combine Records stage, I have keycolumn as col1 and subrecordoutputcolumn as subrec. I have set RunTimeColumn Propagation also. Am getting the output in the output dataset as
subrec
[(A 12) (B 13) (C 14)]
[(D 15)]

Which stage can i use to get the output as
col1 subrec
1 A 12
B 13
C 14
2 D 15
Post Reply