Thread: How can I convert colums into rows

question asked by visitor altay

in datastage how can i convert colums into rows?

in table i have:
-----------------------------------------
id name tel
-----------------------------------------
1 xxxx 222 22 22
2 xxxx 333 33 33
3 xxxx 444 44 44
4 yyyy 555 55 55
5 yyyy 666 66 66
6 zzzzz 777 77 77

in result table i want to see: -----------------------------------------------------
name tel1 tel2 tel3
-----------------------------------------------------
xxxxx 222 22 22 333 33 33 444 44 44
yyyyy 555 55 55 666 66 66
zzzzzz 777 77 77