Hi,
Thanks a lot for your helps!
We've made it by taking the columns which is going to be calculated to the aggregator stage, and the other ones to a copy stage. Then we merged these with a join, removed duplicates and it worked.
Thanks again.
Search found 2 matches
- Fri Dec 24, 2010 7:47 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Multiple rows into one row
- Replies: 8
- Views: 4139
- Thu Dec 23, 2010 6:51 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Multiple rows into one row
- Replies: 8
- Views: 4139
Re: Multiple rows into one row
Has anyone solved that issue? I have the same problem, but it is more complicated. I have the problem below Key1,Col1,Col2,Col3,Col4,Col5,Col6 1,A,Null,Null,3,6,9 1,Null,Null,B 3,6,9 1,Null,B,Null 3,6,9 I want to have : Key1,Col1,Col2,Col3,Col4,Col5,Col6 1,A,B,B,3,6,9 I don't want to do it with an a...