How to merge the excel table properly

[Vi_ciel]

Hi everyone,

can i ask how to merge table from different worksheet to a single one? i tried using append range like in this https://docs.uipath.com/activities/docs/manage-multiple-excel-files but the end result is overlapping data. how to copy all the data, skip one row, and then another data?
and it is copying to the row, so the new copied data is always below it. Is it possible so the new data copied will be copied to the right (column) insted of below (row)? thank you very much

[ppr (Peter)]

we can implement it by doing a side by side merge:

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…

[Vi_ciel]

Hi Peter,
Thank you for your reply! I sat that thread, but how about if the column doesnt have the same amount of row? i was thinking that assuming B has additional row and C has less row, can it be copied all the same? because i have another automation that does that only if the number of row is the same, but if its the different it will return “there’s no row position x”. Thanks

[ppr (Peter)]

@Vi_ciel
have a look on following flow, supporting different rows count e.g. on dt1, dt2

With datatable merge details:

input / output:

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)

[Vi_ciel]

Hi @ppr
thank you for your solution, i somehow get the idea outlined in your example but i cant really put it inot the solution, i tried doing it and it gives error “Input array is longer than the number of the columns in this table”. do you mind taking a look?