Unable to loop all excel records

Help Robot
,
1

I have the file with about 94000 records but if I loop through the file using foreach activity the bot is able to loop approximately 45000

What could be the reson for this issue
I’m using versio 2021.4.4

2

Hi @Malusi_Ngubane

Do you get any error?

Thanks

3

Hi @Malusi_Ngubane,

Can you share a screenshot of the loop?

Regards,
MY

4

Hello @Malusi_Ngubane

Did you set any range ??

5

if you have a large number of records best way is go with VBA script macro

6

No Errors coming up

7

I did not set the range

8

Use Linq Queries in this case.

Please share some details of what are you trying to fetch so we could help you

9

I have two excel files that contains customers
file A(Big file) and file B
Both of these files share same column name: ID number

My task:
In file A i want to find all customber that exist in file B
Then remove them from file A using ID number column

I tried vlookup solution but the solution is very slow it’s runs forever

I wil appreciate if i can find Linq Queries to achieve this.

10

Could you share the two excel files ?

11

Please Use sheet A and sheet B
ABD.xlsx (11.8 KB)