Merge Data Tables

[Beere_Plays]

Hey!

I Have two Data Tables with the Columns:

DT1:
Event, Date

DT2:
Date

So now my Two Databases looks like this:

DT1:

Event,Date ← Column
Event1,
Event2,
Event3,

DT2:

Date ← Column
Date1,
Date2,
Date3,

So Now i want to Merge this Two Databases to look like this:

Event,Date
Event1,Date1
Event2,Date2
Event3,Date3

How do i do this???

[ppr (Peter)]

it is a side by side merge case:

How to copy one column from DT A to another column DT B - LINQ query

@Hiba_B Assumptions: take A Col Values when Col is not present in B A and B DataTables have same row count So we can implement a dynamic conditional side by side merge Calculate the cols not present in B: [grafik] [grafik] [grafik] prepare dt 3 and add missing cols /transfer also other col settings e.g. datatype [grafik] [grafik] Merge rows: [grafik] (From i In Enumerable.Range(0,dt2.Rows.Count) Let raB = dt2.Rows(i).ItemArray Let raA = arrMissingCols.Select(Function (x) dt1.Rows(i…

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)

[raja.arslankhan]

@Beere_Plays
For Each Row and create an index variable for the For Each loop. Change the Assign to:

CurrentRow("Date") = dt2(index)("Date").Tostring

Note: This only works if both dt1 and dt2 has the same number of rows.

(Pic is just help with different same scenario)

[Anil_G (Anil Gorthi)]

@Beere_Plays

If the order and number of rows are same…then you can directly do a add data column on dt1 with column as dt2.Columns(“date”)

Cheers

[Manish540 (Manish Shettigar)]

Hi @Beere_Plays

Check this below attached workflow,
Uipath_MergeDataTables.xaml (9.9 KB)

Hope this might help you