How can you transpose rows to columns and vice versa and what transformations would you choose?
Pls explain how to do the mapping..
Printable View
How can you transpose rows to columns and vice versa and what transformations would you choose?
Pls explain how to do the mapping..
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 :)