Hey guys,I'm new here in Outsystems, I'm having a hard time dealing with exporting files as excel. I want to combine their value into one based on the "Name" column.LIke this:Name Column: Captain HeroExpertise Column: C#, SQL Server
Hi Robertson ,
You can use Sql Widget to write your own query. Refer below post to create a query to return comma separated values
https://www.c-sharpcorner.com/UploadFile/ff2f08/comma-separated-value-in-sql-query/
Best Regards
Devendra
You should use AdvanceExcel component to create a custom excel file as per your requirement.
https://www.outsystems.com/forge/component-overview/355/advanced-excel
Hi Robertson,
If you are trying to implement a logic which will export an excel with a list of Name, ... and multiple expertise as comma seperated value refer to the attached oml.
See this demo: ExportStudentExcel
I hope this helps you!
Kind regards,
Benjith Sam
Hi Sam,
Doing this type of operation in memory with bulk download will cause performance issue.
Hi Devendra,
Performance factor can be an issue, I agree with you. Thank you for the knowledge sharing :)
Problem solved!Thank you,Robertson