How to join 2 datatable with 1 column by their indexes

[ppr (Peter Preuss)]

we can do it with a side by side merge (Not merge activity)

find a first introduction on examples here:

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: