This is my dummy datatable [image] I want to write a linq query to remove particular row If row is kolkata then remove it How can i do it using below code (From row In dt_A If(row(“City”).Equals(“Kolkata”)) Then ).CopyToDatatable

Hey @Kira You can use below code (From row In YourDT Where Not row("City").toString.ToUpper.Trim.Equals("KOLKATA") Select row ).CopyToDatatable Try this and let us know the output Hope it helps you out

Hi @Kira DT.AsEnumerable.Where(Function(r) r.ItemArray.Any(Function(x) Not x.ToString.Equals(“kolkata”))).copytodatatable

@Kira dt.AsEnumerable.Where(Function(row) Not row(0).ToString.equals(“Kolkata”) ).CopyToDataTable [image] i Have shared the image Hope this helps

[image] ppr: (From row In dt_A.AsEnumerable() let v = row("City").ToString.ToUpper.Trim Where Not v.Equals("KOLKATA") Select r = row).CopyToDatatable How can i achieve it using skip? (From row In dt_A Where row(“City”).toString.ToUpper.Trim.Equals(“KOLKATA”) Skip row ).CopyToDatatable I …

[image] Kira: I tried this but didnt work what was done in detail, show us the modeling and the input data

dt = (From row In dt_A.AsEnumerable() Let city = row(“City”).ToString.ToUpper.Trim Where Not city.Equals(“KOLKATA”) Select r = row).CopyToDataTable() that includes all rows except those where the City column has the value KOLKATA. Hope it may help you Cheers @Kira

Why don’t you just use the Filter Data Table activity? Simple, easy, quick…you’d have it working already.

@postwick , @ppr , @Vikas_M , @Shiva_Nikhil , @Dinesh_Guptil , @Praveen_Mudhiraj , Which one is better , Linq or Activities I know that these kind of tasks can be done using activities, But i wanted to know why LInq then? According to me, i feel like Linq is Better than activities Please enlig…

Activities are much simpler and easier and faster. Only use LINQ when you need to because an activity can’t do what you want. Linq is not better than activities.

Ohh thanks for the clarification @postwick

Remove particular rows using LINQ

Help Studio

ppr (Peter Preuss) August 20, 2023, 1:42pm 2

in general we would use a filtering with the where operator

dtFiltered =

(From row In dt_A.AsEnumerable()
let v = row("City").ToString.ToUpper.Trim
Where Not v.Equals("KOLKATA")
Select r = row).CopyToDatatable

Handling empty result we do:

Also have a look here

Topic		Replies	Views
Linq query to remove matched rows Studio studio , question , activities_panel	4	102	August 5, 2024
Delete rows in linq Studio	2	4961	March 16, 2020
LinQ to remove data Studio studio , question , designer_canvas	1	96	September 18, 2024
Linq query for deleteing rows Activities excel , activities , question	4	316	December 1, 2023
Filter expression in data row Certification studio	11	2733	July 13, 2020

Remove particular rows using LINQ

Related topics