How can I apply a transpose operation to a table inside a mashzone data feed? I know there isn't an operator for that. What are the alternatives / workarounds?
Thanks.
2 Replies
I understand the issues you exposed. An Implementation of "more flexible" columns would probably lead to major modifications to the code and could affect performance.
Thank you for your answer.
Stephan Freudl on
This depends on your data source. MashZone converts two dimensional cross-tables into a record oriented structure. It has been described here, however, this is not really a transpose but more a multiply.
Why does MashZone not transpose? The number of columns, their name and data type must be known at design time. The rationale behind is that each column has its distinct semantics. Within MashZone you specify columns to do calculations based on. Or you bind columns to chart axis.
If you transposed a matrix the resulting width depends on the number of initial rows. And it become pretty difficult if columns assigned to axis won't be available at run time after a data source changed...