Transpose the matrix

CloverDX Platform
1 
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

2

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.

3

Thanks Slechtaj.

You made my life easy… :smiley: :slight_smile: