How to delete entire Row if a specific column has empty cells

Help Studio
, ,
2

Hi @Tarif_Mohammad ,

As you have already tried with Filter Datatable Activity and Couldn’t Get the Expected Output, We can Give a Try on Linq Operations.

  1. Assuming that you already read the excel sheet using Read Range Activity and Get the Output as Datatable. We can filter the Datatable to Keep only the Rows needed as per your Requirement .

Let’s Say we have Datatable variable, DT, Then we can use the Below Linq Expression in an Assign Activity:

rowArray = DT.AsEnumerable.Where(Function(x)Not(String.IsNullOrWhiteSpace(x("Nebenkontierung_1").ToString))).ToArray

where rowArray is of the Type Array of DataRow.

Next, we can Check if there are any values in rowArray with an if Activity with the Below Condition :

rowArray.Any

In the Then Part, we can use the Below Expression :

DT = rowArray.CopyToDatatable

In the Else Part, we can use the Below Expression :

DT = DT.Clone
2 Likes