Search found 2 matches
- Thu Feb 22, 2018 3:10 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How Pivot Stage works in Server Edition of Datastage 11.5
- Replies: 3
- Views: 14825
Re: How Pivot Stage works in Server Edition of Datastage 11.
Thank you for your response Sharath. How do you connect the stage variable to the sort stage. Also can you please explain more on concatenation of 2nd column.
- Thu Feb 22, 2018 1:36 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How Pivot Stage works in Server Edition of Datastage 11.5
- Replies: 3
- Views: 14825
How Pivot Stage works in Server Edition of Datastage 11.5
Hi, I'm trying to convert multiple rows into one row. I can see the Pivot stage in Processing Palette, but I don't see the properties of Pivot stage other than Input and Output. My data looks like this Number Code 33590 BL 33590 TL 33590 DL Output expected 33590 BL,TL,DL Any help is appreciated.