How to use LINQ on a DataTable in Uipath

linq uipath uipath-activity
Supriyo picture Supriyo · Aug 8, 2020 · Viewed 11.1k times · Source

I am trying to filter a datatable using LINQ Query on Uipath and save the output as datatable format. Where col A has name and Col B has Price. I am trying to filter where price is greater than a value ( price>500) and save both Name and Price of filtered result to a datatable.

Please find the image which I am trying to do.LINQ Query from OutDT

Answer

AnkitKwar picture AnkitKwar · Aug 16, 2020

d1.asEnumerable.where(Function(x1) CInt(x1("salary"))>500).copyToDatatable

or

d1.asEnumerable.where(Function(x1) x1("salary")>500).copyToDatatable if the salary column is already an integer

You may need to add Assembly reference as System.Data.DataSetExtensions if drop down does not appear after you type d1.asEnumerable.

Related questions

Group by in LINQ

Let's suppose if we have a class like: class Person { internal int PersonID; internal string car; } I have a list of this class: List<Person> persons; And this list can have multiple instances with same PersonIDs, for example: …

Read More
LINQ query on a DataTable

I'm trying to perform a LINQ query on a DataTable object and bizarrely I am finding that performing such queries on DataTables is not straightforward. For example: var results = from myRow in myDataTable where results.Field("RowNo") == 1 select results; This …

Read More
Join/Where with LINQ and Lambda

I'm having trouble with a query written in LINQ and Lambda. So far, I'm getting a lot of errors here's my code: int id = 1; var query = database.Posts.Join(database.Post_Metas, post => database.Posts.Where(x => x.…

Read More