Does PRPC Supports Transpose?
Is there any OOTB rule available for Transpose Column values as Row values?
We are looking to transpose row data of a table into columns of another table as explained below
Example:
Column1 Column2 As Column1 100 101 102 103
100 Test1 Column2 Test1 Test2 Test3 Test4
101 Test2
102 Test3
103 Test4
Pegasystems
US
I know of no prpc feature for this. Depending on whether you're asking about this from an excel angle or a db angle, I suggest you try a web search on the topic. I suppose in prpc you might attempt to use an index table or a set of index tables to simulate this. Take a look at the declare-index rule and see if that gives you any ideas. /Eric
Adqura
IN
Hi Eric,
Thanks for the response.
We are looking for rows in database table to be transposed into columns in a report/excel.
Pegasystems
IN
Please take a look at the trend report functionality in Rule-Obj-SummaryView. This does get data in columns for rows in the database.