How to add three data tables into one data table

Help Activities
, ,
8

@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:

1 Like