How to convart rows to columes in datastage

ntr · Post by **ntr** » Sun May 30, 2010 11:58 pm

Hi all
i have require ment like
source details:
empno,ename,marks
100,vijay,90
100,vijay,80
100,vijay,70

my expected result is
empno,ename,marks1,marks2,marks3
100,vijay,90,80,70
could you please help me for above requir ment

thanks
ntr

ETLJOB · Post by **ETLJOB** » Mon May 31, 2010 12:16 am

Search the forum with the key word "Vertical Pivoting"

chulett · Post by **chulett** » Mon May 31, 2010 6:49 am

Or perhaps just "vertical pivot". In any case, that is indeed what you need to be doing is called.