hi, i have a large dataset in my excel 200,00 count. im using studio x. my problem is when i use vlookup, it take almost one day or more to lookup one by one. is anyone has idea why it take so long or has suggestion to fasten ? because of that, i stuck to continue next script
- Read Range with Filter DataTable Activity:Instead of using the VLOOKUP function within Excel, read the entire dataset into a DataTable using the “Read Range” activity. Once the data is in a DataTable, you can use the “Filter DataTable” activity to perform the lookup operation based on specific criteria. The “Filter DataTable” activity allows you to specify conditions to filter the data efficiently.
- Use LINQ Queries:UiPath supports LINQ (Language-Integrated Query), which is a powerful way to query and manipulate data in collections, including DataTables. By using LINQ queries, you can efficiently filter and perform lookup operations on the DataTable. LINQ queries can be much faster than traditional Excel formulas like VLOOKUP.
Instead of lookup on rhe excel…try to read whole data and then use datatable lookup activities or filter activities
Alternately if you need to fill data…then you can directly write the lookup formula using write cell and fill it till bottom using auto fill range activity
can u please help me to demo this using studio x? i can sent u the sample data
Share your sample excel file and your required output.
Please Sent your sample
Hi, this is my sample im using studio x community
im using sample data, very short data, my real data is quite big thats why i cannot use vlookup. please help me for other alternative
demo.xlsx (8.8 KB)
VLOOKUP.xlsx (8.7 KB)
Hope this helps…
In write Range workbook keep headers as true
If you get the Expected results mark it as Solution.
hi , i only have write cell and write datatable, im using studio x community
Hope it works!!
hi my each row for data table is different, i dont have condition
Try updating UiPath.System.Activities package to latest version to 23.6.0 version. It will help you.
ok will try to find out where to update,
but may i know ask on this step?
why save to A?
It will be easy to configure in the if condition. if not need you can directly give that in If condition too.
Sorry i dont understand this
Is my workflow running for you or is there any issues