how to do reverce pivoting

adisheshu.dwh · Post by **adisheshu.dwh** » Mon Aug 03, 2009 10:50 am

hi how can do reverse pivoting
i/p
ename
aaa
bbb
cccc

o/p
aaa,bbb,cccc

datskosaraju · Post by **datskosaraju** » Mon Aug 03, 2009 1:26 pm

That is not reverse pivoting,that is Vertical Pivoting.

samsuf2002 · Post by **samsuf2002** » Mon Aug 03, 2009 3:45 pm

And can be achieved using PIVOT stage in parallel job.

chulett · Post by **chulett** » Mon Aug 03, 2009 3:50 pm

Afraid not, not until that "direction" is added in a future release as the pivot stage just does columns to rows. This needs a "stage variable concatenation" approach in a transformer to solve, probably with a dummy/trailer row to push out the last group when it hits EOD.

samsuf2002 · Post by **samsuf2002** » Mon Aug 03, 2009 4:10 pm

chulett wrote:Afraid not, not until that "direction" is added in a future release as the pivot stage just does columns to rows. This needs a "stage variable concatenation" approach in a transformer to solve, probably with a dummy/trailer row to push out the last group when it hits EOD.

You are right Craig, I was bit confused in vertical and horizontal pivoting. I believe the transformer logic for this requirement has been discussed here a lot.

chulett · Post by **chulett** » Mon Aug 03, 2009 4:35 pm

It has, and quite recently as well. A search for "vertical pivot" should turn them up. You'll even find one about the "Flush Record" I spoke of needing.