Transpose Collection
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
22-09-17 12:52 PM
How to transpose a collection?
I tried using transpose collection action in collection manipulation VBO but it isn't working.
Does anyone has any idea how to make it work.?
5 REPLIES 5

Anonymous
Not applicable
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
22-09-17 01:22 PM
Transpose Collection"" action creates two columns(Fields) in Output Collection i.e Name(Text) and Value(text). In the Name column you will get Column names and in the Value column you will get respective values of Input collection.
e.g if you have collection name ""Input col"" having one field ""Id"" (with three values 1,2,3) ..and another empty collection called ""Output col"" ..after performing Transpose Collection action your ""Output col"" will get two Fields ""Name"" and ""Value""... and it will look like
Name Value
Id 1
Id 2
Id 3
Hope this helps 🙂
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
25-09-17 10:43 AM
Exactly!
Thank You Mayur.
But this isn't transpose actually, can we use it to perform the actual transpose like that of matrix converting rows to column and column to rows.?

Anonymous
Not applicable
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
25-09-17 11:43 AM
Hi attari,
got your question ..but you will not get exact output as you get in matrix transpose.. you will get output like column_name : value(row1), column_name : value (row2) and so on..can I know why you want such op ?..
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
25-09-17 04:49 PM
i am extracting html table values using regex and each row of the HTML table is coming as column in collection so i am trying to transpose that collection.

Anonymous
Not applicable
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
26-09-17 04:11 PM
yeah.. I think you have to build your own logic for that 🙂
