converting rows to columns

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
srikanthd1978
Charter Member
Charter Member
Posts: 38
Joined: Wed Mar 17, 2004 1:16 am
Location: USA

converting rows to columns

Post by srikanthd1978 »

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
..i did not invent many things..but i can make them Better..
Top
narasimha
Charter Member
Charter Member
Posts: 1236
Joined: Fri Oct 22, 2004 8:59 am
Location: Staten Island, NY

Post by narasimha »

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

Finding answers is simple, all you need to do is come up with the correct questions.
Top
csrazdan
Participant
Posts: 127
Joined: Wed May 12, 2004 6:03 pm
Location: Chicago IL

Re: converting rows to columns

Post by csrazdan »

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
Top
thebird
Participant
Posts: 254
Joined: Thu Jan 06, 2005 12:11 am
Location: India
Contact:
Contact thebird

Re: converting rows to columns

Post by thebird »

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.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”