Combine Records Stage in DataStage

[swapna07]

Hi All,

I am using a dataset as input to a combine record stage which is going to a dataset dile as final output. i have some identical key columns records in my input dataset for which i need to create a sub-set, because of which am using combine records stage.
My input data is as below :
OPTION_ID SCENARIO_ID
1000
1001
1002
1003
1004
1005
1006
1007
1008
1009
1000
1005
1009
My job is running fine but when i view data i get following as output
1000 [() ()]
1001 [()]
1002 [()]
1005 [() ()]
and so on, but i want output with proper values to be displayed in scenario_ID column.
can anyone help me on this?