Unable to export an excel in a customized format

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
  • 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
  • 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