Combine Records Stage
Posted: Fri Oct 09, 2009 2:00 am
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
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