Filter DataTable in UiPath Studio

filter datatable in uipath filter datatable using linq
UiPath - Filter DataTable

It is very important to be able to perform filter operations on DataTable in order to get a desired result.

Let’s take an example of having a table with columns such as FirstName, LastName and Age. We need to filter the records having FirstName as "David".

Input DataTable variable – InputDT
Output Filtered DataTable variable – FilteredDT

Method 1 – Using "Filter Data Table" Activity

Add the variables and conditions as shown below:

filter-datatable-activity-in-uipath-studio
Filter DataTable Activity

We can also choose the columns needed as a resulted FilteredDT, by adding columns via the Output Columns Tab as shown below:

filter-datatable-activity-exclude-column
Filter DataTable Activity - Keep/Remove Output Columns

Method 2 – Using "DataTable.Select() method"

Using this method, we can directly assign filtered rows to a DataRow array or DataTable using below given expression. By default, this method returns the array of data rows, but we can convert it to DataTable.

FilteredDT = InputDT.Select("[FirstName]='John'").CopyToDataTable

Method 3 – Using "DataTable.AsEnumerable() method"

Just write the expression as given below:

FilteredDT = InputDT.AsEnumerable().Where(function(f) f(“FirstName”).ToString=”David”).CopyToDataTable

Method 4 – Using "LINQ"

LINQ method returns IEnumerable by default.

FilteredDT = (From r In InputDT.Select()
Where r("FirstName").Equals("David")
Select r).CopyToDataTable

Location: India

Comments

Post a Comment

Popular posts from this blog

UiPath - Convert String to DateTime

Image
UiPath - Convert String to DateTime We need to convert a string date to DateTime format very frequently whenever we are going to work with date and times. Let’s understand and convert string to DateTime in UiPath using an example below: Step 1 – Take a variable/argument to store the string date in_DateString = "01/01/2020" Assign String Date Step 2 – Take a variable/argument to store the string date format in_DateStringFormat = "dd/MM/yyyy" Assign String Date Format Step 3 – Convert string to datetime using below provided method out_DateTime = DateTime.ParseExact(in_DateString,in_DateStringFormat, System.Globalization.CultureInfo.InvariantCulture) Convert String To DateTime The variable/argument out_DateTime would contain the date value in DateTime format.
Read more

UiPath - Initialize List and Assign Values to List

Image
UiPath - Initialize List and Assign Values to List During developing automation workflow, we need to perform a lot of data manipulation and using list is very frequent. We need to learn about initialize empty list in UiPath and initialize list with values in UiPath. Let’s understand with example 😃 Initialize empty list in UiPath dataList = New List(Of String) Assign - Empty String List to dataList Initialize array with values in UiPath dataList = New List(Of String)(New String(){"value1", "value2", "value3"}) Assign - List with values to dataList
Read more

UiPath - Initialize Array and Assign value to Array

Image
UiPath - Initialize Array and Assign Value to Array During developing automation solutions, we need to perform a lot of data manipulation and using arrays is very frequent. We need to learn about initialize empty array in UiPath and initialize array with values in UiPath. Let’s understand with example 😃 Initialize empty string array in UiPath dataArray = New String(){} Assign - Empty String Array to dataArray Initialize array with values in UiPath dataArray = New String(){"value1", "value2", "value3"} Assign - String Array with values to dataArray
Read more