Skip to main content
Participating Frequently
Aug 11, 2022 9:10 AM UTC
Solved

Pivot Data from/In Expression Rule

Hello!

We are attempting to create a read only grid which will allow the users to export to excel (so data must be a record type) to filter the relevant data into groupings we have an expression rule however the outputs will need to be pivoted to display in a way that is readable/logical on the grid

Data from rule example-

raisedBy: Username1
Status: Complete
Count item: 2
Level:1

raisedBy: Username 1
Status: Complete
Count item: 3
Level: 2

We would want to display this data pivioted i.e.  

RaisedBy                                 Status                             Level:1              Level: 2
Username1                              Complete                           2                        3

Currently we can only display this data as shown below

RaisedBy                                Status                               Level: 1               Level:2
Username 1                            Complete                                5                      5 
Username 1                            Complete                                5                      5


I cannot find information on how to pivot data in Appian is this perhaps called something else?  Is there a way to achieve this in Appian any help would be appreciated!

Thank you! 

stefanhelzle0001
Brainy
Aug 11, 2022 9:29 AM UTC

There is no OOTB function to do that. You will need to implement the algorithm yourself.

3 replies

stefanhelzle0001
Brainy
Aug 11, 2022 9:29 AM UTC

There is no OOTB function to do that. You will need to implement the algorithm yourself.

mikes0011
Brainy
Aug 11, 2022 2:15 PM UTC

Please share the code by which you're currently attempting this logic which is generating your "incorrect" results.  Hopefully an environment-agnostic code sample (with all local variables and no custom rules/constants inherent to your environment), so others here can copy/paste it into an expression or interface designer and try it ourselves.

The Expression Guru
salmak1788
Participating Frequently
Aug 19, 2024 1:31 PM UTC

Were you able to achieve this?