Excel filter how to do with 2 document

I have to filter one excel and want to check document no with anotther excel sheet and if document no is not present in another sheet extract that data and write that data in newsheet

Hello @Kuldeep_Pandey

I think you can use a filter datatable activity to achieve this.

Read both the datatable, loop through the first datatable. Then use a filter datatable activity, by providind the condition based on the lloop. Then use Dt.Rows.count to check the number of rows in the filtered datatable. If it is greater than zero, then you can use append range activity to append to firsg execl.


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