Data table unmatched data

Help Robot
,
1

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)

2

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

3

can you provide me a xml file for this
Output file

4

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

Happy Automation :robot:

5

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