Do you have any suggestion on how to know the range of the DataTable, like the last cell ? For example, the table has thousands of rows and columns, it will may take forever to read if the range is set to " " only. So is there a way to know the last cell? Thank you.
In the write cell range, you can use an alternate method. Create a variable as count and set value as 2. inside loop create assign activity (count = count +1). In the write cell range "D"+count.tostring.
Hello Sir i get this error ("Lookup Data Table: In the 'Target Column category' the value for argument 'Column Name' is not set or is invalid.") please help me to resolve this
Really your explanation is excellent and easy, I benefited a lot I have a question. I have two excel files as in the example, but they have five thousand rows, so vlookup it took a lot of time to execute, more than an hour. Is there a way to do the same function while reducing the execution time?
Thank you so much for appreciating. Also try to check how much time does XL alone takes if you apply a Vlook up directly onto those excel files if there is a huge amount of time difference then do let me know will try to see what best can be done with UiPath
Hi bro, Thanks for the video. I having an issue while doing this activity, am not getting actual values, insted am getting sequence of the values from excel1.
Hi, your videos are clear to understand. I have one exercise, in an excel workbook i have dynamically varying sheets names and i need to read all the sheets in that work book also i have to read a particular column in the sheets which is having a unique color filled cell in that column (ex. Red), i need to get that cell value and search it in a pdf document having the same value on it. If i could identify the value in the pdf then i need to highlight the value in that pdf otherwise the tool should write it in a excel workbook that value is not available in the pdf for that cell value. Kindly help me to done that exercise.
Hi, i could run the flow however it is taking too long (100 cells for 1 hour) to lookup and transfer the data. Is it because of too many rows/cell to transfer or something else? i sheets has over 2000 rows, meaning to transfer 1 column data there will be over 2000 cells. Any way to speed up the process? Thanks
Hi..very nice and informative video..thank u so much. I have one question. if we don't have a primary key present in DT2 for eg I have a sample excel workbook where there are 2 sheets: customers and phone. I want to copy the phone numbers from phone worksheet to customers worksheet. The primary key is customer id. When I ran this workflow a particular customer id was not present in the phone worksheet the phone number field in customer worksheet remains blank. But if we want to fill that field with message like "customer id not present in phone worksheet" can we use try catch. If yes when should we use it.Thanks again
Very excellent explanation. Could you please tell me how we can place the "Not Found" word in the unmatched vlookup values in UiPath. Like in excel, when lookup value not found in lookup column so it places #N/A in the cell. Thanks,
Hi Rakesh, First of all I am thanking you for your all Videos Useful for me and others too. Taking Learning Experience through you Videos... Reg : RPA UiPath / Excel Activity /Lookup Function I am having 1 Master XL Sheet 4 child XL sheet Each Sheet Having 2 headers *SerialNumber(Column A) and *Status (Column C) Target is: At a time Need to update the master sheet based on the SerialNumber from 4 child Sheet *Status. Current Status is : After the studio Design , if I ran a single single Child Sheet na it's updating perfectly. But When I am using the whole child Sheet to update in master sheet it's only printing the SINGLE child Sheet *Status. What it's doing na,, it's is removing the *status Of initially ran child Sheet Status.... Design for single Child sheet, 1 read Range of Master sheet , 2 Read Range of Child Sheet, 3 For Each Row, 3.1 lookup Function 3.2 write Cell Activity. Given Condition is -->> "C"+(DT1.Rows.indexof(row)+2).ToString
Hi , Thank you so much for the sharing the video with us. Also can you teach , how to copy the extracted value inside the table rather than copying to excel column,
Dear, I need a help on how to perform "Right Click" menu click operation in UiPath...on a system screen user list is there. I want to right click anywhere on the list and subsequently a menu will occur. From that menu I would like to click "Save All"... how to do that? Please advice...
Hi, how to ignore case sensitive when perform vLookup? For my understanding if the source and destination have a different small or big letter and the vLookup will failed.
Hey Rakesh, while doing this exercise I am getting the below error. Lookup Data Table: Column 'Item' does not belong to table DataTable. I am using look up value as - row("Item").tostring Column name is "Item" in the excel sheet which I am using as a sample. There are no spaces as well . Not sure what could be the reason. Can you please advise.
I don't understand what is explained here..Subject says Vlookup..But what is explained is 'lookup datatable'. UI path has something specifically 'VlookUp' to compare directly in excel spreadsheets..
Thank you so much for wonderful video, it's very helpful to get understanding of Excel module in detail in UiPath.
A trick : watch movies at Flixzone. Me and my gf have been using it for watching all kinds of movies during the lockdown.
@Keanu Dawson yea, been watching on flixzone for months myself :)
@Keanu Dawson yup, been watching on flixzone for years myself :)
@Keanu Dawson Yup, have been using Flixzone for since december myself =)
This perfectly captures both the functionality in excel (for those that need a refresher) and how to accurately complete it in UiPath. Fantastic job!!
This video was a life saver for me, thank for such thorough explanation
Glad it helped! Nikhita
You have covered a very commonly needed topic and explained in easy way...thank you!
Thank you 😊 for the note
Thanks for the clear explanation through out the video, I liked your brief description below every video and it was very helpful for me & also all.
Thank you so much for wonderful and informative video....👍👍😊😊
Great Job! Continue your learning journey
Great video !!thanks for help
Thank you
Thanks for the video. It really helped me a lot.🙌🙌
Awesome to know
Very nice video, clearly explained, made my day, thank you so much
Do you have any suggestion on how to know the range of the DataTable, like the last cell ? For example, the table has thousands of rows and columns, it will may take forever to read if the range is set to " " only. So is there a way to know the last cell? Thank you.
I have the exact same question
Use datatable.Rows.Count.ToString
You are indeed a life saver mate! Thanks alot!
Thanks Parth
In the write cell range, you can use an alternate method. Create a variable as count and set value as 2. inside loop create assign activity (count = count +1). In the write cell range "D"+count.tostring.
Yes even that works
Hello Sir i get this error
("Lookup Data Table: In the 'Target Column category' the value for argument 'Column Name' is not set or is invalid.")
please help me to resolve this
muy buen video, lo explicas genial. Thank you!!
Gracias 😊
Great video! thank you!
Your videos help me alot i have a question that as we do vlookup i want to do xlookup, can you explain how should i do that .
Really your explanation is excellent and easy, I benefited a lot
I have a question. I have two excel files as in the example, but they have five thousand rows, so vlookup it took a lot of time to execute, more than an hour. Is there a way to do the same function while reducing the execution time?
Thank you so much for appreciating. Also try to check how much time does XL alone takes if you apply a Vlook up directly onto those excel files if there is a huge amount of time difference then do let me know will try to see what best can be done with UiPath
Thank you, can we use something else and then write a cell because it takes a lot of time.
Very useful video. Thank you.
Thanks for knowledge very nice ,I want to know if I want vlookup for two columns how to do it
Hi bro,
Thanks for the video.
I having an issue while doing this activity, am not getting actual values, insted am getting sequence of the values from excel1.
Hi, your videos are clear to understand. I have one exercise, in an excel workbook i have dynamically varying sheets names and i need to read all the sheets in that work book also i have to read a particular column in the sheets which is having a unique color filled cell in that column (ex. Red), i need to get that cell value and search it in a pdf document having the same value on it. If i could identify the value in the pdf then i need to highlight the value in that pdf otherwise the tool should write it in a excel workbook that value is not available in the pdf for that cell value. Kindly help me to done that exercise.
Can we have a video to demonstrate automation of Salesforce lookup object using Uipath?
nice video sir .thank you so much
👍
Hi, i could run the flow however it is taking too long (100 cells for 1 hour) to lookup and transfer the data. Is it because of too many rows/cell to transfer or something else? i sheets has over 2000 rows, meaning to transfer 1 column data there will be over 2000 cells. Any way to speed up the process? Thanks
Is possible to filter data in excel and vlookup for filtred data which are visible
if the range is Dynamic, then how we can manage to select, Please explain bro?
Hi..very nice and informative video..thank u so much. I have one question. if we don't have a primary key present in DT2 for eg I have a sample excel workbook where there are 2 sheets: customers and phone. I want to copy the phone numbers from phone worksheet to customers worksheet. The primary key is customer id. When I ran this workflow a particular customer id was not present in the phone worksheet the phone number field in customer worksheet remains blank. But if we want to fill that field with message like "customer id not present in phone worksheet" can we use try catch. If yes when should we use it.Thanks again
Very excellent explanation. Could you please tell me how we can place the "Not Found" word in the unmatched vlookup values in UiPath. Like in excel, when lookup value not found in lookup column so it places #N/A in the cell. Thanks,
Hi Rakesh,
First of all I am thanking you for your all Videos Useful for me and others too. Taking Learning Experience through you Videos...
Reg : RPA UiPath / Excel Activity /Lookup Function
I am having
1 Master XL Sheet
4 child XL sheet
Each Sheet Having 2 headers *SerialNumber(Column A) and *Status (Column C)
Target is:
At a time Need to update the master sheet based on the SerialNumber from 4 child Sheet *Status.
Current Status is :
After the studio Design , if I ran a single single Child Sheet na it's updating perfectly.
But
When I am using the whole child Sheet to update in master sheet it's only printing the SINGLE child Sheet *Status.
What it's doing na,, it's is removing the *status Of initially ran child Sheet Status....
Design for single Child sheet,
1 read Range of Master sheet ,
2 Read Range of Child Sheet,
3 For Each Row,
3.1 lookup Function
3.2 write Cell Activity.
Given Condition is
-->> "C"+(DT1.Rows.indexof(row)+2).ToString
Informative Video..Thanks.
Thanks Ravi
@@AutomatewithRakesh I am facing one issue in Output cell value. For me it's showing Object instance is not set. Can u plz help me.
ravi kant Misra check if the variable is initialised
@@AutomatewithRakesh sure I will update you abt this...as of now , I used Excel vlook up formula and used write Range..
It's taking time..can u plz let me know which one take less time..as I am having arrnd 40K records in one sheet
sir what I do for multiple columns target in lookup data table activity
Hi , Thank you so much for the sharing the video with us. Also can you teach , how to copy the extracted value inside the table rather than copying to excel column,
Suppose my Customer ID column in one of the excel is unordered. Will it still work?
Hi.. Can't we achieve the same using the join activity... and is using the join activity for this purpose better?
To some extent yes, as you know Vlookup is used extensively in Microsoft Excel and using this activity eases the task
Dear, I need a help on how to perform "Right Click" menu click operation in UiPath...on a system screen user list is there. I want to right click anywhere on the list and subsequently a menu will occur. From that menu I would like to click "Save All"... how to do that? Please advice...
Sure, use the click activity and in the property panel select Right Mouse click option
Hi ..In the same example how can we extract multiple columns. Your feedback would be highly appreciated.
What is the version of Sutdiox used in this tutorial?
StudioX is not for developers… use Studio Pro community edition
Hi, how to ignore case sensitive when perform vLookup? For my understanding if the source and destination have a different small or big letter and the vLookup will failed.
Best of my knowledge vlookup is not case sensitive, it looks only the value
Hi i tried this but im getting entry key already exist error at the Write Cell step. Pls help
I had a issue, when i have 2 different "Customer ID" they duplicate the first row and don't insert the correct value.
Hey Rakesh, while doing this exercise I am getting the below error.
Lookup Data Table: Column 'Item' does not belong to table DataTable.
I am using look up value as - row("Item").tostring
Column name is "Item" in the excel sheet which I am using as a sample. There are no spaces as well . Not sure what could be the reason. Can you please advise.
Use the index number instead of Name.
Which version of excel are you using?
@@AutomatewithRakesh can you advise on the function on how to pass the index in look up value
@@AutomatewithRakesh 2013 version
Is there another way to do lookups? I have large data and it takes a lot of time executing
Hi Alonso what if applying vlookup directly on excel does it take the similar time to process the large dataset? Try to compare
@@AutomatewithRakesh it doesn't, in excel is faster
Bro I did the same workflow but I am getting " column does not belong to the data table " error.
Check if you have saved the excel check if the column name of type properly
Hi sir, I have followed you but it is taking too much time while running please tell me how can I reduce this time ? Please help me
how to use vlookup for multiple columns.colud you give me the answer.
Hi Rakesh it would be good if you include the excels in the discriptions
Sure will try that Alfred generally I keep on working on the same excel file and forget to upload
how to make a write range after the first activity is finished using for each. thanks
Inside a ForEach loop write range is not an ideal choice
For each row is working on each single data so I would recommend use of write cell
Bro. Plz make a video about regular expressions in uipath
Sure will do
Done😄
what to do if data is null?
Hi r u providing online course
Hi Soundhar I was but not planning for any recent classes
I don't understand what is explained here..Subject says Vlookup..But what is explained is 'lookup datatable'. UI path has something specifically 'VlookUp' to compare directly in excel spreadsheets..
sathya022 what is the activity name in uipath studio?
@@AutomatewithRakesh : VLookup is the active name. You can find under StudioX.. Uipath.Excel.Activities
Description - Finds data in a range or sheet using Excel's VLOOKUP function.
sathya022 ahh you are using Stidio X possible! StudioX is made for businesses and people where coding skills are not required
sathya022 do you have the same in uipath studio professional is the question? I don’t see it as of today!
Good
Helpful! Thank you 💗