topic Transpose Collection - Rows to Column in Product Forum

Transpose Collection - Rows to Column

SebastianTorp — Mon, 05 Mar 2018 18:24:00 GMT

Hi all, Has anyone had any luck transposing a collection from rows to column? In short, I have a collection with one row and many columns which I transpose in order to get many rows with two columns (name & value). Now I want to transpose it 'back' again to its original state. I have tried to look into the code of the transpose action, but without any luck. Any input would be greatly appreciated. Thanks, Sebastian

Have you tried the transpose…

Denis__Dennehy — Mon, 05 Mar 2018 19:25:00 GMT

Have you tried the transpose collection action in the collection utility vbo? I have never used it myself but it might be what you are after, if not the code in it might be a starting point for you.

The problem with the…

SebastianTorp — Tue, 06 Mar 2018 12:54:00 GMT

The problem with the transpose collection action is that it can only transpose from column to rows, but not 'back' again. I have tried looking at the code, but my coding skill are limited, especially in Blue Prism 🙂