Transpose Collection

[Ansar_AhmedAtta]

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.?

[Anonymous]

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 🙂

[Ansar_AhmedAtta]

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]

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 ?..

[Ansar_AhmedAtta]

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]

yeah.. I think you have to build your own logic for that 🙂