Rows to columns and vice-versa

[tanya_j]

How can you transpose rows to columns and vice versa and what transformations would you choose?
Pls explain how to do the mapping..

[cme_prak]

Hi,
src table:
eno colname colval
-------------------
1000 name prakash
1000 age 24
1000 sal 25000
1001 name srini
1001 age 21
1001 sal 25000

output:
eno name age sal
------------------
1000 prakash 24 25000
1001 srini 21 25000

logic:

src-------->agg---------->tar
in agg:

step 1: create the o/p port, for getting the name of the employee o_name
iif(colname='name',colval)

step 2: create the o/p port, for getting the age of the employee o_name
iif(colname='age',colval)

step 3: create the o/p port, for getting the sal of the employee o_name
iif(colname='sal',colval)

step 4: please enable group by option for the employee number.

Please get back to us in case of queries.

Thx,
prakash