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...
Forum Discussion
You basically want to look at the Array functions to do something like this generically.
https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1438091/Array+Functions+and+Properties
I’ve attached a sample pipeline that converts the date columns into an array then uses JSON Splitter to get individual records.
Generic Pivot Example_2021_03_30.slp (4.7 KB)
