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
converting rows to columns
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 38
- Joined: Wed Mar 17, 2004 1:16 am
- Location: USA
converting rows to columns
..i did not invent many things..but i can make them Better..
Re: converting rows to columns
Converting rows to columns in not supported in DataStage. You will have to write your own code in buildop for achiving this functionality.
Assume everything I say or do is positive
Re: converting rows to columns
Or you can use a Transformer to achieve this.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.