Using Pivot in DataStage

                                                        

Here the source is taken as an excel file(.csv extension) and the data contains

Name Qty1 Qty2 Qty3

abc      10     20    30

def       70     60    50

After pivot stage (as described in figure) the derivation done is as follows in output column

                  Derivation

Name         Name

Qty             Qty1 Qty2 Qty3

(please make sure the datatype should be same in derivation column)

hence,The destination (flat file in thi example) will be

Name   Qty

abc       10

abc       20

abc       30

def        70

def        60

def        50