Converting Rows to columns
I have Relational source like his.
JAN FEB MAR APR
100 200 300 400
500 600 700 800
900 100 200 300

I need to convert these rows into columns to the targe.

MONTH TOTAL
JAN 1500
FEB 900
MAR 1200
APR 1500

Please experts help me

Answer Posted / dev

hi Raj, plz explain, what we need to do in expression
transformation...

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the commit type if you have a transaction control transformation in the mapping?

655


what is the size ur source like(file system or database)? how many record daily come u r banking project?

1753


What is rank index in rank transformation?

608


Define pmcmd command?

625


How to elaborate tracing level?

688






How to load the data from a flat file into the target where the source flat file name changes daily?

579


Why filter transformation is an active one?

565


What is Data Caches size?

658


What is exclusive and normal mode for repository services?

716


What is the difference between source qualifier transformations source filter to filter transformation?

589


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

602


How can we use batches?

606


What is joiner change?

686


Implementation methodology

1266


differences between service based and product based?

1568