Row comparison in parallel

devsonali · 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 · Post by **samsuf2002** » Wed May 06, 2009 1:14 pm

This is a pivot requirement (rows to columns), search the forum for "Pivot".

ray.wurlod · Post by **ray.wurlod** » Wed May 06, 2009 4:54 pm

Vertical pivot.

chulett · Post by **chulett** » Wed May 06, 2009 10:39 pm

I'm assuming the output should actually end up as:

a xyzpgryrd

Yes?