Transpose data from Excel

Could someone tell me how to transpose data from excel. My Excel input has Pivot data, i need to transform everything to rows.

I started with File reader and then used Excel parser to define the row and column, but not sure how to transpose data. Please suggest.


@Marimuthu86 Try Pivot Snap. For more info Please refer this topic Link

Hi sandeep,
It seems that this pipeline tranforms data from Json input.
My input file is Excel source and i’m facing error when i try to follow same steps.
please suggest.

1 Like

Hi @Marimuthu86,
Make sure your Excel parser’s settings are configured to begin at your data grid.
Here’s an example pipeline and input file that does this. Hope it helps!

1 Like

Thanks it helped me as well. i got a quick question.

I have added some javascript to the HTML files i need to build the pipeline such that it reads the spreadsheet and returns the data within( this bit has been done) For my next step i want something that if i update data in spreadsheet it should reflect changes on HTML file?

if you can help me that would be great.

Please find attached Demo Display (7.3 KB)