Indicating flag in excel sheet

[Abad_Sid]

I am basically using to for loops in my workflow. My workflow matches the data of two different excel sheets and then write the matching rows in one excel sheet and not matching in the other one. The problem is that in the not matching excel sheet some of the data is of matching.New XLSX Worksheet (2).xlsx (8.5 KB) New XLSX Worksheet.xlsx (8.5 KB)
These are the excel sheets.
Main.xaml (46.5 KB)
This is my workflow.Check the first nested for loops

[Palaniyappan (Palaniyappan P)]

Hi
Kindly have a view on this thread

Compare Datatables one specific column with other specific Column and Get Matched and Not Matched Records`

Hello Community Use Below Code to Compare 2 Datatable Column and Get Matched and Not Matched Records Note- Based on your datatable column datatype update datatype here with column field. To Get Matched Records Datatable Out_Matched_Data = In_DataTable1.AsEnumerable().Where(function(row) In_DataTable2.AsEnumerable().Select(function(r) r.Field(Of Int32)(In_DT2_ColName_To_Match.ToString)).Any(function(x) x = row.Field(Of Int32)(In_DT1_ColName_To_Match.ToString))).CopyToDataTable() To Get Not…

Cheers @Abad_Sid

[Abad_Sid]

Kindly plz check my workflow.