Return type of Linq on Datatable

Question

I have a data table with two columns ID & Role. The same ID can have multiple roles. I need to convert this table to a comma-separated grouped table. I am trying to use the following query but unable to solve the issue.

LINQ:

From row As DataRow In dtData.Rows.Cast(Of DataRow)

Group row By id = row.Field(Of Integer)("ID") Into Group

Select ID, Role = String.Join(",", From i In Group Select i.Field(Of String)("Role"))

 

Issue 

Any help will be appreciated.

Update 1:

Table structure

Needed table Structure

Answer 1

try by creating a linq like in your comments just that this returns a list of arrays of string:

Here is the code:

(From row As DataRow In myDatatable Group row By id = row.Field(Of String)("ID") Into Group Select {id, String.Join(",", From i In Group Select i.Field(Of String)("Role"))}).ToList

If you need the result in a datatable you can build a new datatable

Make a for each of result and use the activity Add data row. In ArrayRow add the item and in DataTable the new data table

If you use the activity Output data table you can see the results