• State Not Answered
  • Replies 3 replies
  • Subscribers 5 subscribers
  • Views 3321 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Reports

Unable to export an excel in a customized format

papiyas

I need to export data in a excel.

Currently I am able to export data in a excel in the following format like 

Name Roll Age Phone Teacher
student1 1 13 9876545666 Ram
student2 2 13 4234234234 Ram
student3 3 14 7655578883 Ram

 

But I want to display in the following format:

Teacher Ram    
Name Roll Age Phone
student1 1 13 9876545666
student2 2 13 4234234234
student3 3 14 7655578883

 

Like here,Ram is the teacher which appears in every row.

But the requirement is we want it to appear in the top of the  excel.

Currently I an using ExportableDataSubset here.

Please help on this.

  Discussion posts and replies are publicly visible

Parents
  • 0
    Would you need to use two create excel smart services ?

    Where the first one creates the 1st row for the teacher, the output from that Smart Service then becomes the input for the second where you can add the other content.

    I'm not sure as I've not played with excel creation in Appian much.

    Maybe someone else will be able to point you in the right direction ?
Reply
  • 0
    Would you need to use two create excel smart services ?

    Where the first one creates the 1st row for the teacher, the output from that Smart Service then becomes the input for the second where you can add the other content.

    I'm not sure as I've not played with excel creation in Appian much.

    Maybe someone else will be able to point you in the right direction ?
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.