I Have two Data Tables with the Columns:
So now my Two Databases looks like this:
Event,Date ← Column
Date ← Column
So Now i want to Merge this Two Databases to look like this:
How do i do this???
it is a side by side merge case:
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)
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”)
Check this below attached workflow,
Uipath_MergeDataTables.xaml (9.9 KB)
Hope this might help you