How to combine row from two datatable

[Suastrian_Dika (Dika)]

Hi,

How to combine the row from two datatable

to this :

[Usha_Jyothi]

use merge data table activity

Hope this helps

[ppr (Peter Preuss)]

your case is a side-by-side merge

How to merge the excel table properly

@Vi_ciel have a look on following flow, supporting different rows count e.g. on dt1, dt2 [grafik] With datatable merge details: [grafik] input / output: [grafik] Kindly note: in case of multiple datatables will have the same column name, it has to be handled in advance by making the col names unique find starter help here: SideBySideMerge_AlsoDifferentRCnts.xaml (10.8 KB)

[Dilli_Reddy]

Hi @Suastrian_Dika

-Read the Two DataTables
-Create a New DataTable and Combine rows
Use a For Each Row activity to loop through each row in the first DataTable (dt1) and add them to the combinedDataTable.
-(dt2) and also add them to the combinedDataTable.

Like this…

For Each Row in dt1
combinedDataTable.Rows.Add(row.ItemArray)
For Each Row in dt2
combinedDataTable.Rows.Add(row.ItemArray)

Cheers…!

[Yoichi]

Hi,

If number of rows of the dataable is same, the following will work

Sequence.xaml (11.5 KB)

Regards,

[Usha_Jyothi]

Main.xaml (12.8 KB)

Hope this clarifies
Usha