Combine the values in one row when exporting | OutSystems 11

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 Hero
Expertise 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 ,

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


mvp_badge
MVP

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

TWA_Lab_ExportStudentXL.oml

Hi Sam,

Doing this type of operation in memory with bulk download will cause performance issue.

Best Regards

Devendra

mvp_badge
MVP

Hi Devendra,

Performance factor can be an issue, I agree with you. Thank you for the knowledge sharing :)


Kind regards,

Benjith Sam

Problem solved!

Thank you,
Robertson


Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.