topic yeah.. I think you have to in Product Forum

Transpose Collection

Ansar_AhmedAtta — Fri, 22 Sep 2017 11:52:00 GMT

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

Transpose Collection"" action

Anonymous — Fri, 22 Sep 2017 12:22:00 GMT

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 🙂

Exactly!

Ansar_AhmedAtta — Mon, 25 Sep 2017 09:43:00 GMT

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

Hi attari,

Anonymous — Mon, 25 Sep 2017 10:43:00 GMT

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

i am extracting html table

Ansar_AhmedAtta — Mon, 25 Sep 2017 15:49:00 GMT

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.

yeah.. I think you have to

Anonymous — Tue, 26 Sep 2017 15:11:00 GMT

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