Append 2 Different Datatable

[ppr (Peter Preuss)]

@Palaniyappan

We can use JOIN DATATABLE activity where you can pass two dt and get the above output with FULL join method

we can do it with a side by side merge (not using merge datatatable activity)

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: