How can I transpose the data in reports from Database ?

Question

Hello, 
 I have to create a report in which iam fetching the datas from Database using a function a!exportDataStoreEntityToExcel(). 
 Is that possible to transpose the data from DB which is like Column to row or row to column using this service ?

Stefan Helzle · Accepted Answer

No. Data transformation capabilities are very limited in Appian as a BPM platform and no ETL platfom. 
 If you need to do that, depending in your actual requirements some pre-processing in database using stored procedures might be a solution.

Vinita Jain · Answer

Hi Jeevika, 
 As far as i understand you cannot do that because Appian will fetch the data in export exactly how it is there in DB , every column will have its own data it will be difficult to manipulate the data. 
 Thanks, 
 Vinita Jain

How can I transpose the data in reports from Database ?

Top Replies