Data table unmatched data

hi team
please check with these two excel data given below
please provide me the workflow of unmatched data
We have to compare bank date and credit amount to sap posting date and amount in doc currency and if data is unmatched, write unmatched data into another excel
SAP.xlsx (8.6 KB)
Bank.xlsx (9.4 KB)

Hi @Kuldeep_Pandey ,
Try this one

In_DataTable1.AsEnumerable().Where(Function(row) Not In_DataTable2.AsEnumerable().Any(Function(x)( x(“In_DT2_ColName1_To_Match”).ToString=row(“In_DT1_ColName1_To_Match”).ToString) AND x(“In_DT2_ColName2_To_Match”).ToString=row(“In_DT1_ColName2_To_Match”).ToString) ).CopyToDatatable

can you provide me a xml file for this
Output file

Hi @Kuldeep_Pandey , (21.9 KB)
PFA the working project file.

Happy Automation :robot:

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