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.
@uipath @tesoro @UiPathMaster SequenceTest.xaml (10.3 KB)
Hope you are well just a quick I have please if you may have a look here.
September 9, 2021, 11:08am
Sounds like a side by side merge
Have a look here:
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:
prepare dt 3 and add missing cols /transfer also other col settings e.g. datatype
(From i In Enumerable.Range(0,dt2.Rows.Count)
Let raB = dt2.Rows(i).ItemArray
Let raA = arrMissingCols.Select(Function (x) dt1.Rows(i…
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)
Another option is to write out the different DataTables to the same sheet just by ofssetung the range to right for each datatable