How to concatenate two columns in datatable without looping and keep concatinated data in new column?

[sarathi125 (Parthasarathi)]

Hi,

Check this link, they tried the similar stuff only.

How to Copy entire Column(multiple columns) from Datatable

Hi there, I think I understand you are wanting to store the entire column into string to be used to paste into SAP. String.Join(System.Environment.NewLine,DataTable.AsEnumerable().Select(Function(s) s("Column1”).ToString).ToArray()) Then, you can use Set Clipboard or use the string directly into SAP. To do multiple columns, you can assign the expression again but change the column name or use column index. Here is what I used to test the expression: JoinColumn.xaml (5.5 KB) Hope this helps…