Combine 5 columns of a datatable into a single column separated by comma without looping

Help Activities
,
1

Hi I want to Combine 5 columns of a datatable into a single column separated by comma without looping

Input

image

2

Hi,

Can you try the following sample?

dtResult = dt.AsEnumerable.Select(Function(r) dtResult.LoadDataRow({String.Join(",",r.ItemArray)},False)).CopyToDataTable()

image
image754Ă—657 20.8 KB

Sample20230718-2L.zip (8.6 KB)

Regards,

3

You have to loop. Any solution will loop.

4

  1. Assign activity: dataTable = (your DataTable)

  2. Assign activity: concatenatedStrings = String.Join(“,”, dataTable.AsEnumerable().Select(Function(row) row(“Column1”).ToString() + “,” + row(“Column2”).ToString() + “,” + row(“Column3”).ToString() + “,” + row(“Column4”).ToString() + “,” + row(“Column5”).ToString()))

  3. Log Message activity: concatenatedStrings

5

Thank you! @Yoichi

It’s working perfectly.

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.