Lookup activity too slow

[velizar]

Hi,
So i have a few excel files that i need to preform a lookup on.I first read all the files into datatables and then lookup the value of each row of the main datatable,but that is too slow becouse these files have 300000 400000 rows and it will take it 3 hours to go through. How can i speed up this process?Is there a way?

[vishal.kp (vishal)]

You should use LINQ query for speeding up the process.

[Palaniyappan (Forum Leader)]

Hi
Welcome back to UiPath community
Kindly have a view on this

Excel Vlookup Using UiPAth

Hi, I wold like to perform vlookup using UiPath, I have a excel file in that I have 2 Sheets (Sheet1 and Sheet2) in both the Sheet I have a common column (userId) with unique value, I want to do a lookup in Sheet one which tell me the common userId in both sheet, I have attached the screenshot of my excel file for reference. [Vlookup] How can we do this in UiPath. Thank You!!!.

Cheers @velizar

[ppr (Peter Preuss)]

@velizar
In general WE can Formulate a LINQ Statement using the Join logic and I agree to @vishal.kp

In Case you need Further Help so provide us some Sample Data and expected Output description. So WE can Work Out an individual solution for you

[rafadominici]

Hi @vishal.kp , could you help me please? I’m trying to build a LINQ query but I can’t get it

[Dave (David Wiebelhaus)]

@rafadominici you need to provide information for us to help. It may be best to create your own topic as well.

At a bare minimum, you should provide a sample input, the expected output (based on the sample input), and also provide what you have tried so far. If you do that, then everyone on the forum would be more than happy to help and we will help find a solution

[rafadominici]

Hi @Dave, I created a new topic for my problem.

Thanks