Forum Discussion

saisantosh25's avatar
saisantosh25
New Contributor II
6 years ago

Converts the Columns into Rows

hi , I have a requirement where in to read the .xls file which is having data and transpose the columns into rows and create a csv file as a output . Below is the screenshots for the input and outp...
agt0613's avatar
agt0613
New Contributor
5 years ago

Hi Precy,
Did you ever find a solution for this? I have the same use case.

Precy's avatar
Precy
New Contributor
5 years ago

Hi,

I used below function to get it done.

$.entries().filter(x => ['Fields to be not part of pivot’].indexOf(x[0]) == -1).map(x => { Fieldname: x[0], Field Data Column Name : x[1] })