I have two different excel files. one file is master data file and another excel file is where the values to be filled by searching ID column in master data file. There are nearly 49k rows to be filled.
I have used LookUp data table activity and searching data from master file and filling data into the 2nd file. Since there are more than 49k rows in my 2nd excel file, the robot is taking longer time to fill the values into my 2nd file. It took nearly 30 minutes for the robot to fill the data for just 2100 rows. but a lot more rows(47k rows) to be filled in my 2nd excel file which will take more than an hour.
I request you to suggest me how to achieve this. (I am doing VlookUp activity)