I have two excel file need to compare

Help Something Else
1

Hi Team ,
I have two excel reports need to compare …I have stored them ina data table dt_emailreport and other one is dt_wmsreport .the output like screen shown .

The image is a spreadsheet displaying order numbers and corresponding descriptions, with highlighted sections detailing cases for matching and unmatched entries. (Captioned by AI)
The image is a spreadsheet displaying order numbers and corresponding descriptions, with highlighted sections detailing cases for matching and unmatched entries. (Captioned by AI)1439×652 36.1 KB

Output need in three variable --Please help on this logic .

  • lstAuchanGroupOrders
  • lstUnmatchedOrders
  • lsmatchedOrders
2

@Thumu_Suresh

1st case it will select all order number with receiver desc does not start with number

FilteredDT = DataTable2.AsEnumerable().
Where(Function(row) DataTable1.AsEnumerable().
Any(Function(orderRow) orderRow("OrderNumber").ToString = row("OrderNumber").ToString) AndAlso
Not System.Text.RegularExpressions.Regex.IsMatch(row("receiver desc").ToString, "^\d")).
CopyToDataTable()

2nd case where it will select all order number with receiver desc start with number

FilteredDT = DataTable2.AsEnumerable().
Where(Function(row) DataTable1.AsEnumerable().
Any(Function(orderRow) orderRow("OrderNumber").ToString = row("OrderNumber").ToString) AndAlso
System.Text.RegularExpressions.Regex.IsMatch(row("receiver desc").ToString, "^\d")).
CopyToDataTable()

3rd case unmatched orders

UnmatchedOrdersDT = DataTable1.AsEnumerable().
Where(Function(row) Not DataTable2.AsEnumerable().
Any(Function(orderRow) orderRow("OrderNumber").ToString = row("OrderNumber").ToString)).
CopyToDataTable()