Skip to Content (Press Enter)
UserImage.jpg
SWAMYDURAI SARAVANAN
33Views
4Comments
How to display two aggregate results into a CSV single file?
Question
Import/Export Data

I have a requirement to display two output results in a single CSV file.
Expected output is as below (Below Excel is used to show an example but I want output in CSV format),


I retrieved data from two different tables and displayed the results in separate sections of the same file. Rather than merging the columns, each set of results is shown in its own distinct section.  
Please help me to figure out how I can build the logic for this scenario.

0
0
30 Mar 2023
Copy Link
2018-10-29 08-31-03
João Marques
 
MVP

Hi Swamydurai,


I would definitely use the Advanced Excel forge asset for that.

It enables you to do a lot of things on the scope of importing / exporting an excel file, including your need of multiple tables.

It includes extensive documentation and a complete demo with plenty of use cases to learn how to implement them.


Kind Regards,
João

0
0
30 Mar 2023
Copy Link
UserImage.jpg
SWAMYDURAI SARAVANAN

Hi Joao,
Thanks for your reply. Sorry, I want to export the report in CSV format not in excel.

0
0
30 Mar 2023
Copy Link
2025-10-18 11-13-53
Ramesh subramanian

Hi Swamydurai, 

Please use  Advanced Excel forge. Use this server action create a worksheet and Add two aggregate results into a single file,

Thanks,

Ramesh

0
0
30 Mar 2023
Copy Link
UserImage.jpg
SWAMYDURAI SARAVANAN

Hi Ramesh,

Thanks for your suggestion. I am looking to output the mentioned scenario in CSV format.

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