I have 2 excel sheets, one with 4 rows and other with 6 rows, I want to get all the rows from sheet1 and the not matching extra rows from sheet2 and paste the combination of both in sheet3.
please assist in how to achieve this scenario… thank you so much in advance.
Welcome to our UiPath community.
Use Join DataTable activity to do this.
Have a look below thread.
Welcome to forum
For your question i am assuming that
dt1- datatable after reading sheet1
dt2- after reading sheet2
Now to get uncommon rows from dt2 use the below linq
now append the dt1 and dt_uncommon in same excel sheet using append range or merge datatable activity
Is there a way to compare only one column between the datatables?
I want the output as below
u can try this
dt1 —> sheet1
dt2 -----> sheet2
dt3_uncommon= (From r1 in dt2.AsEnumerable
Where dt1.AsEnumerable().Where(Function(row) row(“Organization Name”).ToString.Trim.Equals(r1(“Organization Name”).ToString)).Count=0
Now use append range or merge datatable to merge the dt1 and dt3_uncommon to a excel sheet.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.