Search found 1 match
- Mon Nov 10, 2008 8:29 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Vertical pivoting of data
- Replies: 2
- Views: 3348
Vertical pivoting of data
Hi I need help on vertical pivot of source data using datastage. source Data: ID type 100 1 100 2 101 1 101 2 102 1 102 3 Target data should be:(Need to send) ID Type1 Type2 Type3 100 1 2 - 101 1 2 - 102 1 - 3 How could we acheive this in Datastage???