Hi Manish, is there a way to use Dictionary Key in Select Method. For Example, I've a Dictionary Key called 'MP' for the Name 'Manish Pandey', then how to use that Dictionary Key in Select Method. Datatable.select("Name='"+outConfig("MP")+"'") is not working.....
Hi Manish Sir, how can we use the select method to filter date based on the current date? where the column date should be filtered if it is less or equal to DateTime.Now
Excellent video Manish Pandey ji, small doubt, in this video last section ie. getting required data from config file with out using for each, filtereddata.select("Name='URL'")(0)(1).tostring, in this if i have 10 columns, i want to fetch the data of column 2,column 6,column 8 and column10 where column name is "Name". how? like i need to give filtereddata.select("Name='URL'")(0)(2)(6)(8)(10).tostring or different......pls reply
how to filter data form DATATable DT1 using Variable as a collection(array, list ...): VC1 Filter City Column form DT1 having data (Mumbai, Pune, Nagpur, Nashik, Thane, Aurangabad) for only VC1 (Pune, Nagpur, Thane)
alomost you are covered the all activities in data table sir but you are didn't touch the merge,create and lookup activites plese make one video on those activities.
In my UiPath Studio I cannot see the '.Select' method description like you have it in 7:30 timestamp. Do you happen to know how to get these descriptions? Should they be availabale from the default installation?
Instead of for each, can we have the filter data into Datatable directly... instead of for each. Please be informed .CopyToDatatable is not recognized to add at end to select query.
Hi Manish , I have tried the date time program , but I am having an error that String converter cannot convert from System.DateTime Please help me with this error
how can i apply it on imap list of mail message like i have subject name in excl and i want getimap activity to select email whose subject is mentioned in the excel please help
Yes, very soon I am going to upload video for Re-Framework. But before that I want to make video for all the activities which is going to be used in Re-Framework. And then you guys will be able to understand Re-Framework easily.. Re-Framework is nothing but just a template in which all automation best practices is used.
Nice, congrats, your chanel is Awesome, already i have a dude, how can i select the last Value in the Datatable that i made? im adding new data but i have to check the new data with the last value of the data table
@@UiPathRPA hi manish please make vedio on reframework. Please make vedio in a sequence such that 1) state machine 2) types of reframework 3) use and and best practices
Thanks for suggestion. Very soon I will be uploading video for Re-Framework. But before that I want to make video for all the activities which is going to be used in Re-Framework. And then you guys will be able to understand Re-Framework easily.. Re-Framework is nothing but just a template in which all automation best practices is used.
@@UiPathRPA i have one more issue i watched your video of config file and when i am trying that ...in assign activity where we do use select method; it is showing me the error compiler error encountered.End of expression expected.
![ผัวเถื่อน - ยูริ โตเกียวมิวสิค [ OFFICIAL MUSIC VIDEO ]](http://i.ytimg.com/vi/P08ORRVDGl8/mqdefault.jpg)
One question Manish,this select method is not working when Column Name contain Spaces .for example 'Total Value' this is not working? Please help
You can use the trim function with that. It will remove the space.
You can put the column name in [] when it has a space. E.g - ("[Total Value] =60")
@@niravrodatta4587 Actually this works thanks ...Niravro
@@niravrodatta4587 thank you brother....you saved me
Hi Manish, is there a way to use Dictionary Key in Select Method. For Example, I've a Dictionary Key called 'MP' for the Name 'Manish Pandey', then how to use that Dictionary Key in Select Method.
Datatable.select("Name='"+outConfig("MP")+"'") is not working.....
Hi Manish Sir, how can we use the select method to filter date based on the current date? where the column date should be filtered if it is less or equal to DateTime.Now
Hiii Manish, Please tell me the Uipath package that you are using.
Excellent video Manish Pandey ji, small doubt, in this video last section ie. getting required data from config file with out using for each, filtereddata.select("Name='URL'")(0)(1).tostring, in this if i have 10 columns, i want to fetch the data of column 2,column 6,column 8 and column10 where column name is "Name". how? like i need to give filtereddata.select("Name='URL'")(0)(2)(6)(8)(10).tostring or different......pls reply
You have to write select method for each column and store in a variable for further use. For ex: DataTable.Select("Name='URL'")(0)(2)
why it is single quote on city name and dob?
how to filter data form DATATable DT1 using Variable as a collection(array, list ...): VC1
Filter City Column form DT1 having data (Mumbai, Pune, Nagpur, Nashik, Thane, Aurangabad) for only VC1 (Pune, Nagpur, Thane)
alomost you are covered the all activities in data table sir but you are didn't touch the merge,create and lookup activites plese make one video on those activities.
Please go through playlist. You will get every thing.
th-cam.com/play/PL41Y-9S9wmyKbV0spfeG-TiM3LyTG6mLY.html
Tq for your reply sir
In my UiPath Studio I cannot see the '.Select' method description like you have it in 7:30 timestamp. Do you happen to know how to get these descriptions? Should they be availabale from the default installation?
Hi Manish, I like your videos. Can u make a video to compare two columns in excel containing strings and highlight the similarities.
Yes sure. Thanks for suggestion. I will make a video for this.
Instead of for each, can we have the filter data into Datatable directly... instead of for each.
Please be informed .CopyToDatatable is not recognized to add at end to select query.
Thanks
This channel is just like a dictionary for all uipath developers.. u can find whatever u want here.
Let's learn about Datatable Select Method in UiPath.
Hi Manish , I have tried the date time program , but I am having an error that String converter cannot convert from System.DateTime
Please help me with this error
Hello Manish great initative from you ,Keep it up!!
Thank you so much!
Thanks, I need to make a filter in an excel so that I get everything except # N / D, would you know how?
how can i apply it on imap list of mail message like i have subject name in excl and i want getimap activity to select email whose subject is mentioned in the excel
please help
Please Make a video on reframe work
Yes, very soon I am going to upload video for Re-Framework. But before that I want to make video for all the activities which is going to be used in Re-Framework. And then you guys will be able to understand Re-Framework easily.. Re-Framework is nothing but just a template in which all automation best practices is used.
Nice, congrats, your chanel is Awesome, already i have a dude, how can i select the last Value in the Datatable that i made? im adding new data but i have to check the new data with the last value of the data table
i only have one Column, or look the last 5 values
Another great video Manish keep going👍
Thank you Saahil...If you have any suggestion, please don't hesitate to write here.
@@UiPathRPA hi manish please make vedio on reframework. Please make vedio in a sequence such that 1) state machine 2) types of reframework 3) use and and best practices
Thanks for suggestion. Very soon I will be uploading video for Re-Framework. But before that I want to make video for all the activities which is going to be used in Re-Framework. And then you guys will be able to understand Re-Framework easily.. Re-Framework is nothing but just a template in which all automation best practices is used.
Nice VDO!! Keep it up!!
Thanks!!
How can i contact u...i have some issues in undderstanding plz
Hi manish i tried the approach of filter data in excel but getting error table does not exists can u help in this
Hi did u find the approach of using select method in excel
Hi manish plz make a video how to filter data using select method using excel sheet
Hi Rishab, we already have a video for filter using select method. Can you please explain your requirement?
@@UiPathRPA hi manish i was asking how to filter the excel daata using select method
@@UiPathRPA i have one more issue i watched your video of config file and when i am trying that ...in assign activity where we do use select method; it is showing me the error compiler error encountered.End of expression expected.
Manish my email is rishabraina1991@gmail.com please reply me there as your small help can help me in getting the doubts cleared
Sir, How can we filter data from two data table where the Value matched from both data tables columns
You can use For each row for one datatable and take another for each row inside first for each row then use if condition to check it if it is equal.
@@UiPathRPA Tnx Sir, I used that but for lengthy data its taking too much time , isn't there any query for that
U can use join method
you killed it..
Thank you!!