Deleting rows from Data Table based on values in multiple columns

[atomic]

Hi @Neal369,

Delete rows where 2 columns match

Hey everyone, I have a datatable which I delete the rows where the rows “first quantity” and “second quantity” column values match. But sometimes the excel is exported faulty and for examle, first quantity value is 72 and second quantity column value is 72000, but actually this a column I want to delete. So is there a way I can do something like; if second column quantity value includes first quantity columns value, remove that row from datatable? Since “72000” includes “72” it could do the…

or

Learning LINQ: Remove Rows based on values from two columns

Hello All, I am in the process of learning LINQ and with searching forums have come up with the following query to try and remove rows from a data table based on the values from two columns. in_Dt = in_Dt.AsEnumerable().where(Function(x) Not (x("Location")).Equals(row("Location").ToString) And Not (x("Date").ToString).Equals(row("Date").toString).CopyToDataTable This above code is being run in a for each row loop and the row(“Location”) and row(“Date”) are from a datatable with rows combinati…

or

How to remove a row in a data table based on the content of two columns

I populate a datatable from a scrape of a table on a web page. The data looks like the following: [NAME,SCORE,TOTAL,DATED Bob,0,1234,29/05/2019 Joe,NA,0,01/01/2018 Ken,0,0,22/11/2018 Rik,2345,0,22/11/2018 ] I would like to remove the rows where both Score and Total are 0 and or NA. If either has a value in it greater than 0 or that is not NA, then I want to keep the row. I tried using an IF statement in a For each row and deleting the row if the conditions of the IF were met, but the For…