Skip to main content
June 8, 2023
Question

Transpose The Database

  • June 8, 2023
  • 2 replies
  • 0 views

I have a DB table with Data. I have transpose the details in front end. Please help me how to do that. Below are the screens shots for reference.

In Database table is like below

Desired in Appian Interface

    2 replies

    mathieud0001
    Brainy
    June 8, 2023

    I would use a combination of a!keys and a a!forEach to transpose the data after running the query.

    stefanhelzle0001
    Brainy
    June 8, 2023

    About how much data are we talking? Trying to load larger data sets into Appian memory is not a good idea.