Search found 1 match
- Tue May 23, 2017 6:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Concatenation
- Replies: 3
- Views: 2414
Concatenation
Hi, I have Multiple records with some having same key ID.I want to concatenate them eg input: ID Col 1 a 1 b 1 c 1 d 2 d 2 e 2 g 3 e 3 s 3 f And the output should be like this. output ID Col 1 a,b,c,d 2 d,e,g 3 e,s,f anyone who know the solution please help me with this. Thanks in advance.