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
devsonali
Premium Member
Posts: 155 Joined: Sun Mar 18, 2007 2:31 pm
Post
by devsonali » Wed May 06, 2009 11:27 am
Hey everybody
Have a quick question about one of the issues in parallel , can you let me know what is the best way to compare rows in parallel ?
Scenario
I have rows like
a xyz
a pqr
a yrd
Functionality needed
Compare row 1 and row 2 if the entry in first row is same (here a ) then comcatenate column 2 values and make it as
a xyzpgr
Any idea what stage to use here?
samsuf2002
Premium Member
Posts: 397 Joined: Wed Apr 12, 2006 2:28 pm
Location: Tennesse
Post
by samsuf2002 » Wed May 06, 2009 1:14 pm
This is a pivot requirement (rows to columns), search the forum for "Pivot".
hi sam here
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Wed May 06, 2009 4:54 pm
Vertical pivot.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Wed May 06, 2009 10:39 pm
I'm assuming the output should actually end up as:
a xyzpgryrd
Yes?
-craig
"You can never have too many knives" -- Logan Nine Fingers