UiPath DataTable Select Method | UiPath How to Filter DataTable

[@rajasekharpatnaik5024]

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

[@AutomatewithRakesh]

Congratulations Raj! I am doing good thank you!

[@alanprakash456]

@@AutomatewithRakesh could you pls suggest what are important topics to be prepared for the rpa devolper interview

[@kirankiran-bf3ow]

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.

[@smitasingh4034]

Hello, I got my UiPath adv exam in the coming January. Thank you for all your guide, it really means a lot.

[@AutomatewithRakesh]

Thank you! I am Happy to know about it!

[@jgsclanil.299]

I'm doing a course on UiPath and every time I got stuck u save me. Thanks again!

[@bindreerastapur2971]

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.

[@AutomatewithRakesh]

Thank you! Continue your Learning Journey

[@bindreerastapur2971]

@@AutomatewithRakesh after making changes on Assign Activity in Expression(

[@satishch2383]

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😎

[@AutomatewithRakesh]

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

[@khyat2013]

Simply Superb.. Thank you very much Rakesh for this Certification tutorial Series.. It Really help in learning all the concepts from basic to advance ..!!!

[@dark47wolf84]

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.

[@AutomatewithRakesh]

This is great to know! Sure will try to create a content around this topic

[@dcdcdcdc-lu7sc]

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

[@AutomatewithRakesh]

Thank you I will look on to it

[@adityadushing9645]

Loving your work ! Please put videos on lambda expression while working with Datatables.

[@AutomatewithRakesh]

Thank you, sure will do

[@shahithnaga5512]

Thank You sir it helped a lot..........

[@AutomatewithRakesh]

Glad to hear that Shahith

[@mohdqamaruddin6197]

thank you so much for this video

[@AutomatewithRakesh]

Thank you

[@netrareddy5467]

please make some video in sql and database also...

[@AutomatewithRakesh]

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

[@nathanmora9734]

You're a Machine

[@AutomatewithRakesh]

Nathan 😍I feel this is A certificate of appreciation for me thank you for liking our contents thank you for believing in me

[@alladinb9710]

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]

[@krishnakrishh9589]

Hi Could you please make a video on LINQ concept in UiPath

[@AutomatewithRakesh]

Sure Krishna we are going to soon start that

[@jyothiankaraju7358]

Hi Rakesh!! Great video, Please make videos on lamda expression

[@ramchandru886]

Thabk you so much

[@AutomatewithRakesh]

You are welcome 🤗

[@matiaselizalde8829]

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

[@AutomatewithRakesh]

Thank you, first try to sort the dat table in asc order and try this : Top10DT = SortedDT.AsEnumerable().Take(10).CopyToDataTable()

[@matiaselizalde8829]

@@AutomatewithRakesh thank you so much, it worked perfectly. Subscribing...

[@satishch2383]

Could you please make videos on linq ..how to group by using and for loops

[@AutomatewithRakesh]

Yes Satish I will post contents related to Linq In the upcoming days

[@polugopi8194]

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.

[@vishnuprasad9619]

👍👍

[@dharmikaroyal3637]

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?

[@AutomatewithRakesh]

Try to use the VLookup logic, please use this video Dharmika: kzbin.info/www/bejne/oHSUgaKYZ5uarJo

[@renukhalkho9055]

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.

[@MYWORLD-xp2pp]

🙌🙌🙌🙌

[@AutomatewithRakesh]

Thank you

[@HustleGamer347]

Hii Rakesh,please do a video on how to sent WhatsApp messages dynamically using Uipath.

[@AutomatewithRakesh]

Will do soon

[@SyedSAhmed3]

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.

[@pratheep-prem]

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.

[@sarahsyed5293]

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 !

[@really696]

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??

[@alladinb9710]

did you find the answer? looking for the same...

[@rajt4722]

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

[@safiratanty537]

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

[@gopikrishna2583]

Dear Rakesh,Put videos regarding UIARD certification and how to prepare for it

[@AutomatewithRakesh]

Yes look at the playlist for certification. I am going to create contents and add there

[@onlinework290]

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

[@Truthshouldwin]

How can we extract the data of a specific month or a specific data...please make a video please 🙏🏿🙏🏿🙏🏿🙏🏿🙏🏿

[@subbu4754]

Hi, Help me How to remove filters in UiPath ??? By using Ctrl+Shft+L

[@TheYogShakti]

Thanks a lot sir but not getting activity(Excel Process Scope)please help me which package I need to install.

[@AutomatewithRakesh]

Hi Jemma Click on Project tab Click on settings and enable modern design you should be able to see the excel process, activities

[@TheYogShakti]

@@AutomatewithRakesh thanks for the prompt response Sir

[@vikrantrai0102]

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 .

[@nikefrost9973]

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)).

[@neetumehta7058]

Hi Rakesh Can we do same scenario using Excel application scope then read range?

[@kalyang9950]

Hi Rakesh, How can we give variable instead of value in select?

[@shuhratjonzikiryaev9685]

Hello Rakesh, I really like your videos. do you have any courses on Udemy?

[@EmpoweringMindBody]

How to filter dates? If someone wants to display a record from before certain date. how to do that?

[@HemanthVlogs]

How to filter based on doesn't contains in datatable

[@mahendrareddy2831]

hi Rakesh how can i save this same file in sheet 2?

[@palliboyalapoornima1269]

Sir how to filter date by month coloumn in Excel

[@alanprakash456]

How to filter dates i am trying to do it but shows error when i followed ur steps pls help

[@docoRPA]

Why not just use the Data Table Filter Wizard?

[@Foodblogging_]

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

[@FarmingyalamandaReddyvideos]

Hi Rakesh, How to use multiple excel files using web Data Scraping?

[@AutomatewithRakesh]

Can you please explain your use case what would you like to achieve

[@mahendramahi769]

Hi sir U r doing well done job Can u pls share u r mail id I'm facing problem with document understanding