DSXchange

hi all,

i have a situation like this

fld
row1 a

row2 b

row3 c

row4 d

and i want the output as


fld1 fld2 fld3 fld4

row a b c d

basically a convertion from vertical to horizontal format...

how do i achieve this ??

Thanks

You might have to use the techinique of vertical pivot
There are many posts discussing this. Check it out

Converting rows to columns in not supported in DataStage. You will have to write your own code in buildop for achiving this functionality.

csrazdan wrote:Converting rows to columns in not supported in DataStage. You will have to write your own code in buildop for achiving this functionality.

Or you can use a Transformer to achieve this.