Combine the values in one row when exporting | OutSystems 11

Back to Forums

Robertson Morales

Solved

Combine the values in one row when exporting | OutSystems 11

Question

Import/Export Data

OutSystems 11

Traditional Web

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

7 days ago

Devendra Singh Baghel

Solution

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

See solution in context

7 days ago

Vikas Sharma

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

7 days ago

Devendra Singh Baghel

Solution

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

7 days ago

Benjith Sam

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

7 days ago