DSXchange

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


o/p
aaa,bbb,cccc

That is not reverse pivoting,that is Vertical Pivoting.

And can be achieved using PIVOT stage in parallel job.

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.

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.

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.