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

[VasuNaidu]

This is the my case:

dt1
Name Account
AA 123
BB 345
CC 654

Output should like this:
Name Account Formula
AA 123 AA123
BB 345 BB345
CC 654 CC654

This should done without loops

Thanks

[sarathi125]

dt1

Name Account

AA 123

BB 345

CC 654

Hi, From where this datatable is populated, there itself you can try to populate the third column as well. Sorry if my understanding is not correct here. Let us know where you are getting the datatable dt1.

[VasuNaidu]

DB or from Excel

[sarathi125]

If it is from DB then we can achieve this using query in the database itself.
If it is from Excel, then append the excel before reading it for the third column then read it.

[VasuNaidu]

Don’t go for excel or DB , I want this manipulation on DataTable only.

[sarathi125]

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…

[nitin_g]

The expected result is single column table with same three rows but two column merged into single column like (A1-b1, a2-b2, a3-b3)