Transpose the matrix

bhavinultimate

• October 31, 2014 00:00

• Answered

Follow

Hi ColverETL Support team,

I have data in spread sheet like
date            inventory         demand           
12/5/13        200                 200
13/5/13        100                 300
14/5/13        200                 400
15/5/13        300                 500

I want to transpose this data and want new excel spreadsheet with columns
date          12/5/13             13/5/13          14/5/13       15/5/13
inventory     200                  100                200              300
demand        200                  300                400              500

Can anyone help me how to do it or send me sample graph similar to this.
You help would be appreciated.

Thanks a lot in advance

• 

  slechtaj

  • October 31, 2014 13:18

  0

  Comment actions Permalink

  Hi,
  
  You do not need to use any extra component to transpose the matrix. All you need to do is to select horizontal Orientation in SpreadsheetDataWriter mapping editor – this will write your records into lines, instead of columns. For more information about this component and its settings refer to our documentation: http://doc.cloveretl.com/documentation/ ... riter.html
  
  Hope this helps.
• 

  bhavinultimate

  • November 01, 2014 07:30

  0

  Comment actions Permalink

  Thanks Slechtaj.
  
  You made my life easy.... :D :)

Please sign in to leave a comment.