Linq helps

Help Studio
, ,
1

hi my datatable is having… Name age salary designation… so i want only those who are having age is less than 30… im using this linq but iam getting error. plz solve this and my erro is
Screenshot 2023-05-12 093101

Screenshot 2023-05-12 092650

2

Hi @katta_nikhil

Please try this LinQ query in the Assign activity:

yourDt = yourDt.AsEnumerable.Where(Function(row) CInt(row("Age").ToString)<30).CopyToDataTable

Hope this helps,
Best Regards.

3

Hi @katta_nikhil

You missed convert to int your row age, we can’t compare string agains int, Kindly try with

(From row In dt2
Where CInt(row("Age").ToString().Trim()) < 30
Select row).CopyToDataTable()

image

Regards!

4

Hi @katta_nikhil

Can you try this-

dtFiltered = dt.AsEnumerable().Where(Function(row) CInt(row(“age”)) < 30).CopyToDataTable()

Thanks!!

5

@katta_nikhil

You can actually use filter datatable activity directly to do this

If need only linq then you can try as below

Dt.AsEnumerable.Where(function(x) Cint(x("Age").ToString)).CopyToDataTable

We can use like this as well

Dt.Select("[Age] < 30").CopyToDataTable

Also it is better to first check the count before copytodatatable to check if atleast one row is returned

Hope this helps

Cheers

6

Hi @katta_nikhil ,
Convert to integer whilst comparing <,>,= with numbers
you can try this…
dt = (From row in dt2
Where CInt(row(“Age”).ToString.Trim) < 30
Select row).CopyToDataTable()