Want to compare excel

hi i have 2 excel i want to compare column where
in first excel name column is Int Number
and 2nd excel column name is SOURCE_NO

i want to get all uncommon data
basically excel 1 has lot of data and 2 has few data that will be from excel 1 only

Hi @manoj_verma1 ,

If you could provide us with the Sample Input Data and the Expected Output for that Input data, we would be able to suggest you a better Solution.

1 Like


Check below link for your reference

Hope this may help you


excel1.xlsx (8.9 KB)
excel2.xlsx (8.3 KB)
here is the sample @supermanPunch

Hi @manoj_verma1 ,

If the Comparison is based on 1 Column and you would want to remove the Matching rows based on the Column from Excel 1. Then we can Do the Following :

  1. Get the Source No.s in a form of an Array using an Assign Activity with the Expression Below :
sourceNoArray = DT2.AsEnumerable.Select(Function(x)x("SOURCE_TRXN_NO").ToString.Trim).ToArray

Here sourceNoArray would be of the Type Array of String and DT2 is the Datatable read from Excel2 sheet

  1. Next, we Filter the values From Excel1 Datatable based on the values present in sourceNoArray :
rowArray = DT1.AsEnumerable.Where(Function(x)Not(sourceNoArray.Contains(x("Int_Number").ToString.Trim))).ToArray

where DT1 is the Datatable read from Excel1 Sheet, rowArray is a variable of Type Array of DataRow

You could Check the Below Workflow :
DT_Remove_MatchingRowValues.xaml (8.1 KB)

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.