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 …

Excel filter how to do with 2 document

Help Automation Ops

system (system) Closed October 20, 2022, 6:03am 3

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

Topic		Replies	Views
Excel data searching Robot robot , question	10	605	November 24, 2022
Filter two excel sheets data and merge the data of two sheets which matches condition Studio studio , question , designer_canvas	2	233	July 4, 2023
How to do this automation Task in Excel? Help datatable , excel , activities , question	15	1044	November 22, 2019
Compare Excel sheets and write data in new sheet Studio datatable , excel , activities , question	17	2056	March 23, 2020
Filter data table issue Help	6	747	September 28, 2019

Excel filter how to do with 2 document

Related topics