Hi Rakesh how are you? I am hard-core follower of your sessions and I cracked an interview in an MNC just because of your videos...thank you so much...keep going
Hi bro this is kiran from bangalore am a rpa beginner so can u help in some case could u give ur whatsapp num have a doubt and stuck in some conditions so.
thank you. still have a question. How could we modify the formla if the salary in table was written like "31k", "18k", "12k". I mean is it somehow possible to split\correct data in the row before we checking the condition? dtEmployee.Select("[Department]='IT' ir [Department]='Finance' AND [Salary]
Hi Rakesh. The way of your teaching and explanation is really motivating. I have used the same activities as you used in this video. After clicking indicate in excel option in read range , the target excel file will automatically open ? or initially we need to open the target excel file and click on indicate on excel ? in my case i am always getting the error " Excel is starting, please try again later" . Do we need to install any separate package ? or do we need to follow any settings ? kindly suggest me.
Yeah really Rakesh I am also following your videos and learning ui path and your explanation is simply good and easily grabbing and reducing the doubts as well.
Simply Superb.. Thank you very much Rakesh for this Certification tutorial Series.. It Really help in learning all the concepts from basic to advance ..!!!
Hi Rakesh sir, Again thanks for you videos'. I always have queries on how actually robots works,, there licensing and allocation to different machines. Below is the question i got while studying from the UiPath Academy and i did not understand it very well could you please explain me. Question : Which of the following sets of jobs can be run simultaneously using a pool of 3 machines connected using the same machine template having 3 runtimes? Options : - 5 jobs created using a foreground process - 5 jobs created using a background process (Correct) -3 jobs created using a foreground process and 5 jobs created using a background process (Correct) -5 jobs created using a foreground process and 3 jobs created using a background process Explanation : An unattended robot can run maximum one foreground process and as many background processes. Hence, from the options presented, those that can be run are those that involve maximum 3 jobs created using a foreground process.
Thank you Satish for liking our content and appreciating on a regular basis.thanks for your support and motivating me to continue to put more valuable content on our channel and eventually help lot of members of the UiPath community and learners
Hi rakesh, great video, thanks. Can you help me with some sintax filtering a datatable with the lowest price options? Im searching for a product in a website, making a data table out of the multiple publications and then filtering by the 10 lowest prices. I dont know what expression should i use in filter-datatable activity or assign, nor do i know how to keep only 10 rows If you could help me i would really appreciate it Thanks in advance
Hi @rakesh, I followed the same steps, i am getting an error messgae saying '.CopyToDataTable' is not a member of 'System.Array' I check both my variables are datatable only. Can you pls help.
Hi Sir, I am growing every day with your vedios...:-) Can you please make a vedio on best practices we have to follow while working on real time project.
Hi Rakesh, Thanks for this wonderful video. I have learned to filter multiple items from excel by this video. I just have a small query: while putting the select statement "v_WorkbookOutput.Select("[Location] = 'Delhi' OR [Location] = 'Pune' And [Name]='Uipath' OR [Name] = 'Bp'")" . I am getting an unwanted extra row with Name = Aron and Location = Delhi. please help me .
Use proper brackets in the Select Query. You might want to separate location and name with brackets like ((loc=delhi or loc =pune) and (name=uipath or name =Bp)).
Sir, if I want to sort the salary column from the largest and in the salary column there are 2 data of the same size, how can I get the row from the column name? please advice
Hi Rakesh, appreciate the effort but the outcome is actually wrong. You need a more accurate use of brackets within the where clause string. AND condition gets the priority over OR condition. This is why you got a name with 30k salary in IT department even though you used a < 30k condition (not
Hi, How to type cast any one of the column? Let's say in your example the salary column is in string format and we need check if salary is less than 30K! Then in the select statement what changes are required??
For example, we have 2 Excel sheets. One excel is having all unique values and the other is having repeated values. We have to filter the data based on unique values in the first excel. Please guide me how to do it?
Hi Rakesh, Thank you so much for your learning videos. Please help/Guide me on the below Scenario in Excel. Have a sheet with Vlookup formula with value in a column. want to delete the entire "Rows" which all having "#N/A" in the column. please guide the way in UIPath. Thanks, Raja
Hi Rakesh, Thank you so much for your each and every learning videos. Please help/Guide me on the below Scenario in Excel. Have a sheet with Vlookup formula with value in a column. want to delete the entire "Rows" which all having "#N/A" in the column. please guide the way in UIPath. Thanks, Raja
Hello Rakesh Sir, Can you please help me in a query How can we combine rows of datatable based on a condition and store it to a string with a dash (-)? I have tried a few things but am not able to combine rows. Thanks for your help in advance
Yes I need to I had certain challenges for the SQL set up I would definitely try to create content around them once everything is up and make it ready for demonstration
Hi Rakesh how are you? I am hard-core follower of your sessions and I cracked an interview in an MNC just because of your videos...thank you so much...keep going
Congratulations Raj! I am doing good thank you!
@@AutomatewithRakesh could you pls suggest what are important topics to be prepared for the rpa devolper interview
Hi bro this is kiran from bangalore am a rpa beginner so can u help in some case could u give ur whatsapp num have a doubt and stuck in some conditions so.
I'm doing a course on UiPath and every time I got stuck u save me. Thanks again!
Hello,
I got my UiPath adv exam in the coming January. Thank you for all your guide, it really means a lot.
Thank you! I am Happy to know about it!
thank you. still have a question.
How could we modify the formla if the salary in table was written like "31k", "18k", "12k". I mean is it somehow possible to split\correct data in the row before we checking the condition? dtEmployee.Select("[Department]='IT' ir [Department]='Finance' AND [Salary]
Hi Rakesh. The way of your teaching and explanation is really motivating.
I have used the same activities as you used in this video. After clicking indicate in excel option in read range , the target excel file will automatically open ? or initially we need to open the target excel file and click on indicate on excel ? in my case i am always getting the error " Excel is starting, please try again later" . Do we need to install any separate package ? or do we need to follow any settings ? kindly suggest me.
Yeah really Rakesh I am also following your videos and learning ui path and your explanation is simply good and easily grabbing and reducing the doubts as well.
Thank you! Continue your Learning Journey
@@AutomatewithRakesh after making changes on Assign Activity in Expression(
Simply Superb.. Thank you very much Rakesh for this Certification tutorial Series.. It Really help in learning all the concepts from basic to advance ..!!!
Hi Rakesh sir,
Again thanks for you videos'.
I always have queries on how actually robots works,, there licensing and allocation to different machines. Below is the question i got while studying from the UiPath Academy and i did not understand it very well could you please explain me.
Question : Which of the following sets of jobs can be run simultaneously using a pool of 3 machines connected using the same machine template having 3 runtimes?
Options :
- 5 jobs created using a foreground process
-
5 jobs created using a background process (Correct)
-3 jobs created using a foreground process and 5 jobs created using a background process (Correct)
-5 jobs created using a foreground process and 3 jobs created using a background process
Explanation :
An unattended robot can run maximum one foreground process and as many background processes. Hence, from the options presented, those that can be run are those that involve maximum 3 jobs created using a foreground process.
Thank you so much for covering all imp concepts.I am learning all new concepts🤗 And most importantly ur way of teaching hats off bro😎
Thank you Satish for liking our content and appreciating on a regular basis.thanks for your support and motivating me to continue to put more valuable content on our channel and eventually help lot of members of the UiPath community and learners
Hi rakesh, great video, thanks. Can you help me with some sintax filtering a datatable with the lowest price options? Im searching for a product in a website, making a data table out of the multiple publications and then filtering by the 10 lowest prices.
I dont know what expression should i use in filter-datatable activity or assign, nor do i know how to keep only 10 rows
If you could help me i would really appreciate it
Thanks in advance
Thank you, first try to sort the dat table in asc order and try this :
Top10DT = SortedDT.AsEnumerable().Take(10).CopyToDataTable()
@@AutomatewithRakesh thank you so much, it worked perfectly. Subscribing...
Hi @rakesh, I followed the same steps, i am getting an error messgae saying '.CopyToDataTable' is not a member of 'System.Array'
I check both my variables are datatable only.
Can you pls help.
Hi Sir,
I am growing every day with your vedios...:-) Can you please make a vedio on best practices we have to follow while working on real time project.
This is great to know! Sure will try to create a content around this topic
Hi Rakesh, Thanks for this wonderful video. I have learned to filter multiple items from excel by this video. I just have a small query: while putting the select statement "v_WorkbookOutput.Select("[Location] = 'Delhi' OR [Location] = 'Pune' And [Name]='Uipath' OR [Name] = 'Bp'")" . I am getting an unwanted extra row with Name = Aron and Location = Delhi. please help me .
Use proper brackets in the Select Query. You might want to separate location and name with brackets like ((loc=delhi or loc =pune) and (name=uipath or name =Bp)).
Hi ... Can you please tell how to copy specific table from an excel sheet and paste it into Outlook mail ? It would be really helpful ... Thanks !
Loving your work ! Please put videos on lambda expression while working with Datatables.
Thank you, sure will do
Hi Rakesh
Can we do same scenario using Excel application scope then read range?
Sir, if I want to sort the salary column from the largest and in the salary column there are 2 data of the same size, how can I get the row from the column name? please advice
Hello Rakesh, I really like your videos. do you have any courses on Udemy?
Hi, how can we achieve this
1. Need to filter all the items in department column one by one and create new file for all items with the filter data.
Hi Rakesh, appreciate the effort but the outcome is actually wrong. You need a more accurate use of brackets within the where clause string. AND condition gets the priority over OR condition. This is why you got a name with 30k salary in IT department even though you used a < 30k condition (not
Thank you I will look on to it
Hi,
How to type cast any one of the column? Let's say in your example the salary column is in string format and we need check if salary is less than 30K!
Then in the select statement what changes are required??
did you find the answer? looking for the same...
Hi,
Help me How to remove filters in UiPath ??? By using Ctrl+Shft+L
For example, we have 2 Excel sheets. One excel is having all unique values and the other is having repeated values. We have to filter the data based on unique values in the first excel. Please guide me how to do it?
Try to use the VLookup logic, please use this video Dharmika: ruclips.net/video/jC1Pob26gv8/видео.html
Hi Rakesh, Thank you so much for your learning videos.
Please help/Guide me on the below Scenario in Excel.
Have a sheet with Vlookup formula with value in a column.
want to delete the entire "Rows" which all having "#N/A" in the column.
please guide the way in UIPath.
Thanks,
Raja
Hi Rakesh, Thank you so much for your each and every learning videos.
Please help/Guide me on the below Scenario in Excel.
Have a sheet with Vlookup formula with value in a column.
want to delete the entire "Rows" which all having "#N/A" in the column.
please guide the way in UIPath.
Thanks,
Raja
Thanks a lot sir but not getting activity(Excel Process Scope)please help me which package I need to install.
Hi Jemma Click on Project tab Click on settings and enable modern design you should be able to see the excel process, activities
@@AutomatewithRakesh thanks for the prompt response Sir
Hi Rakesh!! Great video,
Please make videos on lamda expression
Could you please make videos on linq ..how to group by using and for loops
Yes Satish I will post contents related to Linq In the upcoming days
Thank You sir it helped a lot..........
Glad to hear that Shahith
Hi Could you please make a video on LINQ concept in UiPath
Sure Krishna we are going to soon start that
How can we extract the data of a specific month or a specific data...please make a video please 🙏🏿🙏🏿🙏🏿🙏🏿🙏🏿
Hello Rakesh Sir,
Can you please help me in a query
How can we combine rows of datatable based on a condition and store it to a string with a dash (-)? I have tried a few things but am not able to combine rows.
Thanks for your help in advance
How to filter dates? If someone wants to display a record from before certain date. how to do that?
please make some video in sql and database also...
Yes I need to I had certain challenges for the SQL set up I would definitely try to create content around them once everything is up and make it ready for demonstration
thank you so much for this video
Thank you
hi Rakesh
how can i save this same file in sheet 2?
Dear Rakesh,Put videos regarding UIARD certification and how to prepare for it
Yes look at the playlist for certification. I am going to create contents and add there
How to filter dates i am trying to do it but shows error when i followed ur steps pls help
You're a Machine
Nathan 😍I feel this is A certificate of appreciation for me thank you for liking our contents thank you for believing in me
Hi Rakesh, How to use multiple excel files using web Data Scraping?
Can you please explain your use case what would you like to achieve
Hii Rakesh,please do a video on how to sent WhatsApp messages dynamically using Uipath.
Will do soon
Thabk you so much
You are welcome 🤗
👍👍
Why not just use the Data Table Filter Wizard?
How to filter based on doesn't contains in datatable
Sir how to filter date by month coloumn in Excel
🙌🙌🙌🙌
Thank you
Hi sir
U r doing well done job
Can u pls share u r mail id
I'm facing problem with document understanding