Transpose data from Excel

Question

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

marimuthu86 · Answer

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 · Answer

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)

sandeepvemula · Answer

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

nihil_limbadiya · Answer

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

Forum Discussion

Transpose data from Excel

Recent Discussions

Javascript to promote top level lists

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?

Multipart Reader failure - 'content-type' was not found