Convert Rows to Columns (or Columns to Rows)

[dross]

I have input data which is formatted as a wide csv. Which is where the data’s keys are in the first row, and subsequent rows have values to that key.

Most of pipeline builder uses long csv format, where the primary key is the first column, not the first row.

Example input
1, 2, 3, 4, 5
1, 4, 9, 16, 25

I need this data flipped so that it looks like this
1, 1
2, 4
3, 9
4, 16
5, 25

What operation in pipeline builder will allow me to get the flipped data so that I can do proper pipeline builder operations on the data.

Do I need to write a code repo function?

[arukavina]

Hi @dross,

You can always unpivot your data in Pipeline Builder.
I took your example data I did this:

Then I added a transform to unpivot configured like this:

Final results looks like this:

Is this what you’re looking for?

Please keep in mind that if the number of columns change you may want to improve this to by dynamic.

Let me know if this helped you.

[dross]

That looks like it will work thank you!

I was worried that unpivot was not correct as the new “value” column was putting both the rows into one

(notional data)

But I was able to remove and fix the input data!

Thank you so much!!!

[arukavina]

Glad it worked!

If no are no outstanding issues, feel free to close this topic. Thanks!

Best,