Unmatched data table

Hey teamI have used
DT_2.AsEnumerable().Where(Function(row) not DT_1.AsEnumerable().Where(function(r) r(“Posting Date”).ToString.Equals(row(“DATE”).ToString.Trim) and r(“Amount in Doc. Curr.”).ToString.trim.Equals(row(“CREDIT AMT”).ToString.Trim)).Any).ToArray.CopyToDataTable.DefaultView.ToTable(False,{“DATE”,“Description”,“CREDIT AMT”})
this statement for filter out unmatch data but its also filtering match data
Please help me

HI @Kuldeep_Pandey

Check with this expression

DT_2.AsEnumerable().Where(Function(row) DT_1.AsEnumerable().Where(function(r) not r(“Posting Date”).ToString.Equals(row(“DATE”).ToString.Trim) and not r(“Amount in Doc. Curr.”).ToString.trim.Equals(row(“CREDIT AMT”).ToString.Trim)).Any).ToArray.CopyToDataTable.DefaultView.ToTable(False,{“DATE”,“Description”,“CREDIT AMT”})

Regards
Sudharsan

Same its giving match data aslo

Hey

can you try with

DT_2.AsEnumerable().Where(Function(row) DT_1.AsEnumerable().Where(function(r) not r(“Posting Date”).ToString.Equals(row(“DATE”).ToString.Trim) and not r(“Amount in Doc. Curr.”).ToString.trim.Equals(row(“CREDIT AMT”).ToString.Trim)).Any).ToArray.CopyToDataTable.DefaultView.ToTable(True,{“DATE”,“Description”,“CREDIT AMT”})

Regards

same giving matched data also

use as an analysis techniques the immediate panel and inspect the datatables.
Maybe the Dates do have the same date, but different Timeparts, which will disturb the match

Once this is cleared then we can check for alternates if needed

Understanding the 6 Debugging Panels of UiPath in the easiest way possible! - News / Tutorials - UiPath Community Forum

:ambulance: :sos: [FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues - News / Tutorials - UiPath Community Forum

Bank.xlsx (9.4 KB)
SAP.xlsx (8.6 KB)
Please check with these two excel data
please provide me the workflow of unmatched data
We have to comapre bank date and credit amount to sap posting date and amount in doc currency