Problem with Pivot stage

[mydsworld]

I have the following input :

sr_no
1
2
3

I would like my output to become like this :

sr_no1 sr_no2 sr_no3
1 2 3

How shd I do that. Is it with Pivot ? I tried to use Pivot stage like this :

Row Generator -> Pivot -> Data set

Row generator is geneating those 3 rows.Then my output file was defined with 3 columns.But the jobs runs but I see no data in output.

Please help.

[ray.wurlod]

A Pivot stage goes the other way (columns to rows). What you are attempting to achieve is called a "vertical pivot" (rows to columns). There are several ways to achieve a vertical pivot in DataStage - a Search of DSXchange will reveal them.

[mydsworld]

I tried the Horizontal pivot with Pivot stage :

File -> Pivot stage -> File

The job runs successfully but there is no data in output file. I get the following warning in director log :

Pivot_1,0: Info: Test_Pivot.Pivot_1: Cannot map output derivation of column 'Sr_No' to any input column.

[ray.wurlod]

A Pivot stage will not help your requirement.