Skip to Content (Press Enter)
2023-01-03 18-53-09
Sangam Bhondele
23Views
2Comments
Export data in Excel : one to many
Question
OutSystems 11

How to export data in Excel with list to list .

For ex. For one pan I have different dates of updation , and for next pan I have different date of updation.

Attached format in image.

Any suggestions would be helpful.


IMG20231023144519.jpg
0
0
23 Oct 2023
Copy Link
2021-01-04 08-13-48
Toto
 
MVP

You need to create aggregate with those data or if it not possible, use SQL Query Widget to create the data, then use Download widget to download the data as excel file.

0
0
23 Oct 2023
Copy Link
UserImage.jpg
vikas sharma
Champion

Hi,

As @Toto mentioned you can use aggregate or SQL to get the desired records. Apart from that for generating the excel in required format (given in attachment) you need to use Advanced Excel forge component.  It will allow you to merge PAN number in single row and then multiple dates rows.

regards

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