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?
or you can do this
assign this to your dt variable
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
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.