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