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 ?
Discussion posts and replies are publicly visible
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.
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