I have to delete a particular row

I need to delete a particular row which has year as 2020

do you have excel sample that you can upload?

Not in excel in datatable i have to remove row which has 2020 in year column

if its just datatable can you use **filter datatable activity?
image

or you can do this
assign this to your dt variable
image

dt.AsEnumerable.Where(function(x) not x("Year").ToString.Equals("2020")).CopyToDataTable

You can use Filter datatable and the provide necessary the condition and we will get a new datatable which will not longer have year column 2022

image

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.