Use of Vertical Pivot Stage

[prasson_ibm]

Hi,

I am testing a vertical pivot stage in DS8.5.
I have input like this:-

Code: Select all

"abc","def","jim"
"abc","def","bob"
"abc","def","tom"

And i want output like:-

Code: Select all

"abc","def","jim","bob","tom"

I tried to achieve this result using VPivot stage but i m getting o/p like this:-

Code: Select all

"abc","def","jim","bob","bob"
"abc","def","tom","","tom"

Can anyone tell me whether this can be achieved using Vertical Pivot stage or not.
If yes,how i can derive these values.

Thanks

[chulett]

Mark the first two columns as "key" columns.

[ray.wurlod]

Have you actually read the manual or help for this stage type?