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...
Precy's avatar
Precy
New Contributor
6 years ago

Hi,

Did you find out a solution for this in snaplogic?If yes, can you please share with me . I kind of need similar to this for my workcase.

  • 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] })