How to filter a datatable using Linq

[hacky (NotHacker)]

hi Team,

In my project, I am having a datatable like below: dt_test

I want to count of the rows where Age = “20”

I have been trying to use below logic (seems correct): LINQ operation

But I am getting error sayign that value row is not declared.

i am using namespaces:

1. System.Linq
2. System.Data
3. System.Data.DatesetExtension.

Experts please helps @singh_sumit @ashokkarale @jast1631

[lrtetala (Lakshman Reddy)]

Hi @hacky

Count = DT.AsEnumerable().Where(Function(row) row("Age").ToString() = "20").Count()

Regards,

[ppr (Peter Preuss)]

[HowTo] LINQ (VB.Net) Learning Catalogue

This topic references the different Learning HowTos related to LINQ. It will be updated on new published HowTos as well LINQ Learning: Topic LINK First Start with LINQ [HowTo] - First Start with LINQ (VB.Net) Exploring the LINQ universe [HowTo] - Exploring the LINQ Universe (VB.Net) Operator [HowTo] Overview Topic LINK Where [HowTo] LINQ - First Start # Where Operator Select work in progress Any [HowTo] LINQ – First Start # Any Operator All [HowTo] LINQ – First Start…

And the Where Operator

[HowTo] LINQ - First Start # Where Operator

This HowTo introduces how to use the Where operator. Introduction The Where operator is used for filtering. For the filtering, a condition is provided. All items matching this condition will pass the filter and will be part of the returned result. The condition has mandatory to return a boolean outcome. In other words: The result of the condition has to be True or False. Example IPO Samples Comment Values: 20,3,17,22,10,25,5 A collection of Numbers Filter Condition: x > 15 x is th…

So let us know if you need C# or VB.Net Syntax

[ashokkarale]

@hacky,

You can use a LINQ query in UiPath to count the rows in a DataTable where the age is equal to 20. Here is how you can write it:

Assuming:

• Your DataTable is named dt.
• The column name for age is Age.

The LINQ query would be:

countRows = dt.AsEnumerable().Count(Function(row) row.Field(Of Integer)("Age") = 20)

Explanation:

• AsEnumerable() converts the DataTable to an enumerable collection so that LINQ can be applied.
• Field(Of Integer)("Age") gets the value of the “Age” column for each row.
• .Count(Function(row) ...) counts the rows where the condition (age = 20) is met.

Make sure that the “Age” column is of type Integer. If it’s of another type, like String, you can modify the query accordingly:

countRows = dt.AsEnumerable().Count(Function(row) row.Field(Of String)("Age") = "20")

This query will return the count of rows where the age is 20.

LLM helped me write this but it’s validated by me.

Thanks,
Ashok

[singh_sumit (Sumit Singh Tariyal)]

Hie @hacky check this
your input

note : Count is a integer variable

Output

cheers Happy Automation