LINQ query to append 3 different data tables into 1 data table

[Ray_Sha1 (Ray Sha)]

Hi,

I have 3 data tables

Dt1 is as below:
SrNo
1
2
3

Dt2 is as below:
SrNo
4
5
3

Dt3 is as below:
SrNo
6
7
1

I need a final data table as below

Sr.no
1
2
3
4
5
6
7

Any idea?

[Gokul001 (Gokul Balaji)]

Hi @Ray_Sha1

Have a look on the thread

How to add three data tables into one data table

@Kavya_Mamidishetti2 Create an empty datatble with the three cols with the help of Build datatable - dtMerged then use an assign activity: left: dtMerged right (From x in Enumerable.Range(0, dt1.Rows.Count) Let ra = new Object(){dt1.Rows(x)(0),dt2.Rows(x)(0),dt3.Rows(x)(0)} Select dtMerged.Rows.Add(ra)).CopyToDataTAble Feel free to use ColName instead of ColIndex in case ofg the datatables will have different row counts we can adopt also have a look here:

Regards
Gokul

[ashwin.ashok ((TheCodingTheory))]

Hi @Ray_Sha1 ,

If the schemas are same, then we can use Set Operations to solve this like, the Union Operator to be precise →

dt1.AsEnumerable().Union(dt2.AsEnumerable().Union(dt3.AsEnumerable(),DataRowComparer.Default),DataRowComparer.Default).CopyToDataTable()

If you want to order the items by any of the columns, then you can use an OrderBy as well →

dt1.AsEnumerable().Union(dt2.AsEnumerable().Union(dt3.AsEnumerable(),DataRowComparer.Default),DataRowComparer.Default).OrderBy(Function(o) CInt(o(0).ToString)).CopyToDataTable()

IntersectThreeDataTables.xaml (10.7 KB)

Kind Regards,
Ashwin A.K

[Ray_Sha1 (Ray Sha)]

@ashwin.ashok thanks!