Transpose data from Excel

[Marimuthu86]

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

[SandeepVemula]

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

[Marimuthu86]

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]

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!

• Judy
  PivotFromExcel_2018_09_13.slp (4.9 KB)
  SnapLogic_Pivot.xlsx (8.3 KB)

[nihil_limbadiya]

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