How to delete a row in a data table if row has any empty cells in it

[Abhi15 (Abhi)]

Here in my data table I want to remove 1st, 3rd and 4th rows as the rows are having empty cells. How to do that. Please help.

[vinithareddyk123 (Vinitha)]

Hi @Abhi15
you can use select as Datatable.Select(“[Column3] is null”) = Datarow
(type as datarow) now use for each activity to loop through the datarow , inside for each use remove data row activty.

[prasath_S]

Hi @Abhi15

Please Try this

dtTable - datatable

dtTable = dtTable.AsEnumerable.where(Function(row) row.ItemArray.All(function(col) not string.IsNullOrEmpty(col.ToString))).CopyToDataTable

Thanks

[gRao]

Hi ,
You can as well use Filter datatable activity on empty columns to get rid of those rows.

Thanks,
Geetishree Rao

[Abhi15 (Abhi)]

Hi prasath

The above code is working fine.
Can you explain me the above code, looks like it is vb.net. I’m new to uipath and don’t know vb.net

Thanks.

[MEHER_BJ]

@Abhi15 It is Linq query. The query is iterating through each row in data table (AsEnumerable). In each row it is checking if each column value is not null. The entire output is copied to data table (copytodatatable) and assinged to data table dtTable.

[prasath_S]

@Abhi15 what @MEHER_BJ is correct, thanks for explaining…

[Abhi15 (Abhi)]

Thankyou @prasath_S and @MEHER_BJ .