Skip to main content
J
jeevikashreea0001
May 26, 2021
Solved

How can I transpose the data in reports from Database ?

  • May 26, 2021
  • 2 replies
  • 0 views

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 ?

    Best answer by stefanhelzle0001

    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.

    2 replies

    stefanhelzle0001
    stefanhelzle0001Answer
    May 26, 2021

    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.

      vinitaj0002
      vinitaj0002
      May 26, 2021

      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

      Terms & ConditionsAccessibility statement