Excel sheets validation with more number of data rows

Hi. Guys.

I am trying to validate 2 excel sheets with 12,000 and above data, I have used a simple if condition workflow to compare the rows and if rows matched then write “YES” in a new column. The issue is, when I run the program it takes too much of time to get executed, I am not getting the output at all.

(eg: when I tried to validate sheets with “119222” data it is executed for about an hour but no output!)

Thank You.

Hello @Chendoran_M
Try to use WorkBook activity instead of Excel application scope.
It may little bit faster than Excel application scope

Hi @Chendoran_M ,

Could you let us know what is the approach that you have taken to perform this task ?

I’ve used “Read range workbook”, but still not working.

DataValidate.xlsx (668.6 KB)
Value_Validation_Workflow.xaml (14.6 KB)

Hello @Chendoran_M
Kindly check this Xaml file, You may get some Idea
Value_Validation_Workflow.xaml (18.8 KB)

@Chendoran_M ,

Could you also confirm on whether a Run operation was performed or a Debug ?

If a Debug was performed, it would execute in a very slow manner.

Also, You would not need to use a For Each Row Loop for the inner Data Comparison. We would just need to check if the data is present in any of the rows in the dt_DB datatable, as the updation needs to be done only in the dt_Legacy datatable.

Check the updated workflow below :
Value_Validation_Workflow.xaml (17.6 KB)

Thank you @Gokul_Jayakumar. I have tried it and it works as expected.

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