cancel
Showing results for 
Search instead for 
Did you mean: 

Convert Rows to Columns

skodali
New Contributor III

I’m trying to convert row values into columns. Can anyone suggest me how should I approach to resolve this?

Pic

1 ACCEPTED SOLUTION

Ajay_Chawda
Contributor

Hi Sasank,

Below pipeline might help you to achieve what you are trying.

converRowstoColumns_2019_03_05.slp (16.2 KB)

image

View solution in original post

4 REPLIES 4

Surendar
Contributor

You can try with pivot snap below is the link.

https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1438281/Pivot

Hope this will useful for you.

Regads
Suren

Ajay_Chawda
Contributor

Hi Sasank,

Below pipeline might help you to achieve what you are trying.

converRowstoColumns_2019_03_05.slp (16.2 KB)

image

skodali
New Contributor III

Thanks Ajay it works.

chthroop
New Contributor III

I had the same need before myself. The Pivot is perfect for transforming spreadsheets into lists. I had found this answer before, but had to dig. The example in the Catalog last I checked was a complex approach that wasn’t nearly as easy to use

Snap should put their pivot example into the catalog… We use it every day