Excel sheets validation with more number of data rows

Help Studio
, ,
1

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.

2

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

3

Hi @Chendoran_M ,

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

4

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

5

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

6

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

image
image488×625 5.8 KB

7

@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)

8

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

9

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