Add column to another table

[Brian_Henokh1 (Brian Henokh)]

Hello everyone,

I have 2 datatable (DT1, DT2). I want to add column DT2 to column DT1 but without looping.

Example:
DT1: A,B
DT2: C

Expected:
DT1: A,B,C

Anyone can help me?

[Yoichi]

Hi,

The following post will help you.

How to merge the excel table properly

@Vi_ciel have a look on following flow, supporting different rows count e.g. on dt1, dt2 [grafik] With datatable merge details: [grafik] input / output: [grafik] Kindly note: in case of multiple datatables will have the same column name, it has to be handled in advance by making the col names unique find starter help here: SideBySideMerge_AlsoDifferentRCnts.xaml (10.8 KB)

Regards,

[supriya117 (Supriya Allada)]

Hi @Brian_Henokh1

Try this:

DT1 = (From row In DT1.AsEnumerable() From row2 In DT2.AsEnumerable() Select DT1.Clone.LoadDataRow({row("A"), row("B"), row2("C")}, False)).CopyToDataTable()

[lrtetala (Lakshman Reddy)]

Hi @Brian_Henokh1

Check on this

Adding column data from one datatable to another

Hi all, Need help for the below scenario. i have 2 datatables which are having different columns but i want to add the column from 2nd dt to 1st dt. but not having any common data.(append) any possibilities? using LINQ query Thanks in Advance

Hope this helps!!

[Gokul001 (Gokul Balaji)]

HI @Brian_Henokh1

Can you try with this expression

ResultDT = (From row1 In DT1.AsEnumerable()
           From row2 In DT2.AsEnumerable()
           Select DT1.Clone().LoadDataRow({row1("Column1"), row1("Column2"), row2("Column3")}, False)).CopyToDataTable()