Transpose data from Excel
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 ...
Forum Discussion
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.
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)
- Judy
