cancel
Showing results for 
Search instead for 
Did you mean: 

Transpose data from Excel

Marimuthu86
New Contributor II

HI,
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.

Thanks,
Muthu

4 REPLIES 4

SandeepVemula
Contributor

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

Marimuthu86
New Contributor II

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.

jcampion
New Contributor III

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!

nihil_limbadiya
New Contributor II

HI,
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 Board.zip (7.3 KB)
Thanks