Merge Data Table , Join Data Table query

[Rahul_Singh_Kamboj]

Hi Forum,

Hope everyone is well here,

I have an urgent query to be solved I have been working on this since yesterday evening I am not able to solve it and I don’t have anywhere to go except putting up a question here. I have my pervious question also on which I am waiting to be guided to the right path.

Cleartax.xlsx (17.0 KB)

I want all the sheet data to be present in single sheet with all the headings as the data in sheet1 is relevant to sheet2 and same goes for sheet3

So all data in row 1 after headers should come in single line.

For me if I am using a merger data table its skipping some rows and then inserting data if I am join data table its multiplying the rows and making it 4.

Please Help @uipath @tesoro @UiPathMaster SequenceTest.xaml (10.3 KB)

[Rahul_Singh_Kamboj]

Hi @Srini84

Hope you are well just a quick I have please if you may have a look here.

Regards

[ppr (Peter)]

Sounds like a side by side merge
Have a look here:

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)

Another option is to write out the different DataTables to the same sheet just by ofssetung the range to right for each datatable