I will get input from database i will have to compare input from previous day report.
I need to compare "sales_order_id and Directory_Number columns in both tables
Same sale order can be present in both datatbles. But i have to take telephone numbers which is added new on input sheet only those.
I have tried with below link query but not getting records. Can some one help me on this.
out_strTnDt.AsEnumerable.Where(Function(x) Not previousdayReport.AsEnumerable.Any( Function(y) x(“SALES_ORDER_ID”).ToString.Trim.Equals(y(“SALES_ORDER_ID”).ToString.Trim))).Count > 0