Data360 Analyze

 View Only
  • 1.  Convert multiple columns to rows

    Employee
    Posted 09-05-2021 20:55

    I have 200 columns that need to convert to rows. How can I convert all of them at once?

     



  • 2.  RE: Convert multiple columns to rows

    Employee
    Posted 09-07-2021 06:18

    The 'Pivot - Names to Data' node enables you to transform a data set so that specified fields (or fields that match a pattern) are transposed into records in the output data set.

    Which, with the given node configuration, results in the following output data structure.

    See the 'Pivot - Names to Data' node topic in the integrated Help or view the topic online here.