vertical pivoting

[deepthi]

Hi ,

How can we implement vertical pivoting in datastage.

for eg:

we have

name mon sal
a jan 100
a feb 30
b jan 10
b feb 20


the output should be

name jan feb
a 100 30
b 10 20.

Please advice.

Thanks
Deepthi

[nagarjuna]

This has been discussed many times ...Try to search "Vertical pivot " ....