How to Copy entire Column(multiple columns) from Datatable

Help
,
2

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. Regards!