Want to compare excel

Help Studio
, ,
1

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

2

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
3

@manoj_verma1

Check below link for your reference

Hope this may help you

Thanks

4

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

5

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
6

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