I was previously taught how to delete rows containing duplicate and blank values in a data table.
This time I would like to know how to delete duplicate values in item A, leaving only those with high values in item B, and how to delete rows containing blank values.
Is it possible to do that?
I will post the code you taught me before and a link to the code.
BBBB = AAAAA.AsEnumerable.Where(Function(x) Not (String.IsNullOrEmpty(x("A").ToString) OrElse x("A").ToString.Contains("KEYWORD"))).CopyToDataTable()
You are always there to help when I need it!
Thanks for getting the data ready for me!
Your code worked perfectly!
It is so wonderful.
But there is something I omitted.
There are actually multiple other columns, not just columns A and B.
Is there any way to retrieve all of those rows, not just A,B?