How to pivot this data?

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
manjuak.boya1@gmail.com
Participant
Posts: 4
Joined: Tue Apr 19, 2011 12:11 pm

How to pivot this data?

Post by manjuak.boya1@gmail.com »

i have a source file
column
1
1
2
i want output
11
2
how can i get if i am using pivot and transformer
i get but my output will get like this
column
1
11
2
only i want
column
11
2
hasi
datastage developer
jwiles
Premium Member
Premium Member
Posts: 1274
Joined: Sun Nov 14, 2004 8:50 pm
Contact:

Post by jwiles »

Hasi,

You need to have started your own thread for this question rather than hijacking someone else's thread. I'm sure that Craig will soon take care of that for you. ;)

Regards,
- james wiles


All generalizations are false, including this one - Mark Twain.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Done. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply