Append 2 Different Datatable

[ramadhani.sheffi]

Hello, supposedly i have two datatable each with different column name (no same key at all but have the same amount of row)
example
DT_1
colname1|colname2|colname3|
valueAA | value AB | valueAC |
value BA | value BB | value BC|

DT_2
colname4|colname5|colname6|
valueCA | value CB | valueCC |
value DA | value DB | value DC|

i wanna have an output like this
DT_output
colname1|colname2|colname3|colname4|colname5|colname6|
valueAA | value AB | valueAC |valueCA | value CB | valueCC |
value BA | value BB | value BC|value DA | value DB | value DC|

I’ve tried the merge activities but the output i got is the datatable appended as row. As you can see i’m trying to append the second datatable as a column(with each respective value) for the first datatable. Can someone tell me how to acomplish that?

Thank you.

[Palaniyappan (Forum Leader)]

Hi

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

Join Data Tables

Cheers @ramadhani.sheffi

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

[ramadhani.sheffi]

Thank you for the solution! It works like a charm.