Skip to Content (Press Enter)
2022-02-23 11-51-04
Vijay Bhaskar Reddy Palle
48Views
3Comments
Solved
[Advanced Excel] Export to excel list one of the attribute is other list
Question
Reactive
Forge
advanced-excel
Service icon
Advanced Excel (O11)
Forge asset by Carlos Freitas
Application Type
Reactive

Hey hi,
I'm having a query on exporting to excel of customized list structure with one of the attribute as another list.

Example:

Students list need to print.

My entities: 

Structures:


Expected Excel Export :


Thanks & Regards
Palle Vijay Bhaskar Reddy

0
0
02 Dec 2022
Copy Link
2023-01-17 13-43-47
Akhila K Soman
Solution

Hi Vijay,

You could join the Student and Marks Entity with Student Id in an aggregate and sort it by Student Id. Then execute a For Each loop for each record while saving the Student Id in a local variable each time. 

If the StudentId is same mark the StudentId, Name ,Age and Standard as "-" and export the data to excel. It will generate the expected Excel Report.

Hope this helps.

Thanks,

Akhila

0
0
03 Dec 2022
Copy Link
2022-02-23 11-51-04
Vijay Bhaskar Reddy Palle

It works.

Thanks & Regards,
Palle Vijay Bhaskar Reddy

0
0
05 Dec 2022
Copy Link
UserImage.jpg
Reynor Carta

Hello Akhila K Soman, 

 GoodDay, Can you show the OML in your OML solution


Thank you very much

0
0
26 Jan 2023
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.